I have a Sony cybershot dsc-p1, shoots at 3.3 mp or so.
For holidays and amateur stuff its a great cam, good quality, very nice colors. I even did a model shoot with it and the pics turned out really nice.
I think they are pretty cheap lately, 700 bucks or so.
If you want to do pro shoots id suggest another brand like Canon or Nikon. Im gonna get the
Canon d60.
Altho im not an expert this cam seems to be best best SLR cam available in the prosumer range atm. You wont find better unless you want to pay 10k