I have a Mavica FD-900, at least I think that’s the model number, it was the high end one six months ago. I like it, but there’s some problems, too. I’m no photographer, but I like taking nice pictures.
The resolution is GREAT. 1024x768, great lens, great zoom, etc. I’ve taken some of the best pictures of my life with this camera. At 1024x768, it fits between 6-10 pictures on a disk.
I bought the Sony mainly because I thought it would be nice and convenient to use floppies. After using it for a while, I question that. Say you take 10 disks full of pictures on a trip - to look at 'em, you have to put the disks one by one into your floppy drive and copy them to your hard disk. My understanding is that other cameras come with a memory cartridge that you download to your computer via the serial port or whatever. For large numbers of pictures, this would be more convenient than copying 10 disks.
It also has problems in low light conditions. I’ve had a lot of pictures turn out black because I forgot to adjust the camera. I’m pretty sure, though, that someone who knew what they were doing could adjust the camera so that this wasn’t an issue.
You can also use it to record 10-15 second movies, with sound. I think this is a neat feature, not really useful but sorta whiz-bang. Not the greatest resolution, but OK.
My one single biggest complaint, though, is the thing is HUGE. The 14x zoom lens is big. Some of the lower end Sonys are smaller, but none are tiny. I find myself leaving it in the car because I don’t want to lug it around, while my boyfriend has a tiny camera (non digital) that he puts in his pocket and snaps pictures all the time. Humph.