I got a Sony Mavica CD last Fall. I love it! It is *not* small, but I like that. It's about as big as my Pentax K1000 (don't laugh, it's been good to me!). It is probably the most versatile, easy to use, ease of image transfer camera out there. You do pay for it in speed. I keep mine on highest resolution with an additional write for email size pic's. That means saving 2 images of the same picture. That makes it slow. Using lower resolution and/or not adding the email sized image will speed it up dramatically. It uses mini disks, I keep a few re-writable disks and haven't used anything else. It'll hold a LOT of pictures on a disk, over 100 at high res w/the email secondary image. Mine is a 2.0 megapixel, it has printed out very good qualitiy 4x6's and 5x7's, with cropping down and blowing up some. Larger would be a bit grainy up close. There is a 4 megapixel version, but you do pay for the convenience. ISO equivalent up to 400, which some are only 100, can take video limited only by disk space. Several minutes if you want, with sound, or gif's, low light with or w/o flash and longer exposure times. Does have a rapidfire 3 exposure at a time feature. With Win XP, it's plug and play. Large LCD screen. Battery lasts a long time, the camera displays remaining battery time.
Drawbacks: price, size/weight, speed, no look-through viewfinder.