I"ve got a Sony TRV10 camcorder and a Sony F707 digital still camera. the camcorder take great movies and not so great stills (640x480) but does in a pinch, and the 707 takes great pics, but so-so movies (320x240) but again it's better than nothing.
I believe some of the newer camcorders have stills up to 1.5 and maybe 2 MP, but I'm not sure on the overall quality tho.