I have the Pentax Optio 555 and I can't recommend it enough! It is a great consumer camera with every option imaginable. It is as simple as point and click for the beginner and has all the manual settings for the expert.
It's a 5 MegaPixel with Macro, Super Macro, Manual exposure, shutter...