I have a Sony CyberShot DSC-P100 and LOVE it! You have to have a steady hand but as long as you arent wiggling all over the place the pictures are quite clear I also love that it takes MPEG videos. It isn't too fancy but it has all the different lighting and quality settings.

The best place that I have found for reviews of all the different cameras is:
www.steves-digicams.com