I've got a Cannon Powershot SD600. It does a good job but anything above the optical zoom, which is only 3X, is very grainy. It does take decent point and shoot pics and has some manual settings (which I don't use often).
Uses SD cards and has a rechargable battery that has gone 250+ shots before needing a recharge.
I posted a few pics in a Las Vegas thread a bit back if you want to see how the pics look.
edit:
found it
http://www.tfproject.org/tfp/showthread.php?t=132071
i must have taken a few off but there are still 3 there.