THis is kinda an old thread initially but if you are still interested let me know. I am a proffessional photographer and have not shot with film in close to three years.

I've had many cameras and have seen them all. THere are so many things out there to consider it's really quite a challange. Obviously you don't need a $7000 camera like I use in the studio but I'll tell you that Canon Point and shoots are probably the best bet going. Followed very closely by Nikon and sony.
I have a Powershot A70 for milling around and I do all of my RC vids with it. It will run a High 640x800 res movie for up to 4 min on a large card and unlimited time at a lower res. It has sound and is a great cam! I often print 16x20 prints from it.
There is not much reason to go larger then 4 MPX for an average person. I have a 12 MPX Fuji S3pro that I use professionally but that's way overkill for an average person!
Any questions... Just give a shout... G.