I agree this is a very broad question but I can put down what I use etc.
#1. While I agree megapixels are important. It depends what you want to do with the picture. As the poster above stated, more pixels mean you can crop the picture later to "zoom in on things" or "blow them up" but this will reduce resolution. Now, if you have a 10MP camera, and you crop it down to 5MP, you won't notice, but if you have a 3MP camera and crop it to 1MP....good lord it's going to look bad.
I also agree with the other poster who said getting the most megapixels isn't necessarilly good. As he/she said, the more megapixels, the more space they take up and the bigger/more memory cards you will need.
There is a way around this, that is to get a camera with a good OPTICAL zoom. I personally use the Olympus c-770..which they don't make anymore, but you can get their newer "ultra zoom" cameras. My camera has a 10X zoom (once you've had an ultra zoom you'll never go back) Now, they're small but they're not like the kind you stuff in your pocked, just slightly bigger. It has 4MP. Now the good thing about a camera like this "Good megapixels/high zoom" is if you can zoom in on stuff from a far distance, the less you'll need to crop the picture later. Also, 4MP gives you good resolution.
Now, where megapixels really matter is when you want to print your digital images out to photo paper 4"x6" or 8"x10". If you're planning on printing 4x6's, 3MP is more than enough. I've printed 4"x6"s with a 2.1MP camera and they looked just fine. Now, if you want to print 8x10's (my personal favorite) you really should have at least a 3MP or higher (2MP tends to look fuzzy). You'll be also happy to know I've used my 4MP camera to print poster sized prints that look gorgeous.
I know this is a lot of info but it's just some of the things I look for off the top of my head. A good place to go for camera review is
http://www.dcresource.com/
they have all kinds of reviews of digital cameras along with sample images and videos. I find them very helpful.
In the end it's a very broad question. As people have stated earlier, it depends what you want to do. If you want to just take portrait shots and things that you can get up close to, there's really no need for any zoom. But if you want to use the camera for far away things, say, the castle taken from the train station or....non disney related...say you're at a sporting event up in the bleachers and want to zoom in on one specific player....these are good reasons to get an ultra zoom camera. If I had the money, I'd like to have a super small camera and the one I have now since they both have their place
If you have any more questions I'd be glad to try to help you out. Just drop me a private message!:wave:
Camera Nut,
Jim