3MP is going to be around 2,000px X 1,500px - also known as larger than any reasonable desktop resolution.
Now if you'd like to print some stuff, that'll get you good 5" x 7" prints. I would suggest getting the highest megapixels you can afford.
I am going to purchase the Sony DSC-P10 in June when it becomes available. It is a 5MP camera about the size of a standard cellphone. The Sony Memory Stick format now supports huge capacity (1GB!! ... @ $650 ...) but I'm going to get a 256MB stick for roughly $130. This particular camera also has a Lithium rechargable battery, so that's cool. The camera itself is going to be $500, and I'll get a dinky bag and an extra battery too. All together I'll probably spend $750.
What's your price range?
What do you want to use the camera for?
"I just want a good camera that is going to allow me to get good pictures in any type of situation." --- That's what too broad to give advice on. I'd recommend the Canon EOS D1s. It's 11MP and costs $7,000 (: