Pros: good battery life, Good Low-Light Performance, Nice features/settings, excellent image quality, Bright LCD, Lightweight/Portable, Simple controls/menu, easy to use
Bottom line, this is the best camera I have ever owned. The SD790IS takes great pictures in the auto modes, and allows lots of flexibility in the manual mode to dial it in if you desire. The big screen and great controls enhance the experience, and I love the small size.
The only two complaints I have are: 1) image blurring at the corners due to the lens (not a big deal), 2) the screws fall out that hold the body together. The second was a let down because the construction is otherwise really robust. My sister has the same camera and experienced the same problem. Unfortunately, the first screws to go were the ones holding the wrist strap plate, and the camera fell on a hiking trail, slightly damaging the camera (could have been catastrophic).