Canon PowerShot SX230 HS (Black)

Pros: Extremely good in low light condition (photos)
Video recording in HD
Easy to use interface
14X optical zoom
It comes in pink:)

Cons: 1080P video isn't at 30fps
A bit bigger than compact point and shoot
Flash popup location is akward

Summary: I'm not sure what the editor was talking about. I bought an extra battery just in case. I didn't really need it. The battery life was perfectly fine for every eventual day on my vacation. I did tons of stuff with the camera in those 7 days and I didn't even cover a fraction of the camera's capability.
Let's start with the image from the cmos sensor (if you discriminate against cmos sensor, there is no need to read further, but you are missing out) produces extremely sharp photos. Unless you are a top professional protographer, you aren't gonna do better with a DSLR. The camera handles low light condition extremely well. I can take a picture in candle light condition and it'd look like day light. Why was this good for me? Well, if I turn on the flash, I will get a good focus on the subject, but the background will be dark. Without the flash, I will get a full picture of the subject and the background as if it was under day light!
I have seen some complaints about 1080P not doing 30 fps. That included me. Frankly, it really didn't matter much. It could be that I wasn't taking any action videos (tennis games maybe?)

http://www.youtube.com/watch?v=ST1rB1-pNJE There....check that out yourself. If that doesn't look good to you, get a real video camera:)
(make sure you view it in 1080p instead of the youtube default of 360p, and make sure you have the bandwidth)