Apple QuickTake 100! I remember using it in 8th grade and was pretty amazed with its 640x480 goodness when the alternative was waiting a week to finish a roll of film, drop it off at the grocery store photo counter, and pick it up the next day or two (no way would my parents pay the extra $2 surcharge for 1 hour processing).
I remember a Kodak dc210 whose main feature was 1 megapixel resolution, meaning one could get a 4x6” print that wouldn’t look pixelated. It had zero control (no aperture/shutter speed settings and only crappy slow fixed focus) and took ages to take a picture, meaning it was unusable for moving subject photography. It was still better than other cameras of the time which only achieved vga resolution.
I've got a Casio QV-10A[1] somewhere that almost certainly counts? Can't beat the constant fear that you could brick it if the batteries ran out at the wrong time.
