Personally I like our Sony Mavica CD-300, but you will pay a little extra for it's mass storage feature re-writable cds. most of the pix on our webpage
were taken with it. It's comparable to any other camera in the 3 megapixal range but our camera has been discontinued in favour of a 4 megapixal camera (the CD-400) which would give you even better quality.
As for picking which camera you should buy, it's to bad you can't try a bunch of cameras and see for your self what you like best.