As you have discovered, there is no perfect camera.
Both produce excellent photos.
...........
As for low light photography:
Point-and-shoot cameras are not suited to low light situation (when not using flash).
A camera with manual controls has a better chance, but you will have to use the manual controls to pull it off.
For low light, you should take another look at the Fujifilm F10. They have been working on a different type of sensor for several years now.
And from some reviews I read, it looks like they have succeeded in producing a sensor that has low noise when increasing the ISO. Which you need to do in low light.
They even have a setting as high as ISO 1600, which is unheard of in any camera below a DSLR (digital single lens reflex) camera.
That would be like having an f1.4 lens AND the ability to increase the shutter speed by two stops.
It should work well in most evening parties (without a flash).
...
..
.
I'm new to the digital age of cameras and have been spending some time now looking at digital cameras and looking over reviews and reading up in the forums of several sites. The problem is I still haven't found any conclusive answer to which camera is better, the Canon SD500 or the Nikon 7900.
The reason I?m looking at these two is that I like the small size of both, the design and style. There look easy to carry around any wear and seem to be the best when it comes to this size of camera. I need something that I?ll be able to use down the road, something that takes great photos in all the usual environments, like action shots, day/night shots for outdoors/indoors portraits and landscapes, and dimly lighted evening parties. Since I am a novice and this camera will also be used by others in my family I would like it to be simple to use, for example just leaving it in auto and letting the camera take care of it all.
The problem is that from what I have read, the Nikon 7900 has a problem with low light photos but otherwise is a great camera with unique features like Face Priority AF, Red-Eye Fix, Blur warning, and D-Lighting. With the Canon SD500 I have read that some people have had problems with its LCD cracking and whining during movies and a few posts of it not doing well in dim light. I don't know of any unique features with the SD500 but do know that it is of good quality and it takes great photos.
I was hoping someone with either of the cameras could highlight the pro's/con's that they have found while using the camera, and/or someone comparing them for me. You see all I?ve been able to get so far from others posts that have asked this question is referral to other cameras:
The Fugi f10, seems a little bulky, and seems more towards the manual side of things compared to auto but does look like it takes great photos.
A couple of Sony's, the W7 and P200, both of which I don?t like the shape or style, and in image quality they seem to be below the Canon SD500 or the Nikon 7900.
The Olympus c-7000 again too bulky for me to carry around.
I don't mind paying more, I?d even pay 100 or more then the SD500, but I want a camera that can do what I need it do without shortcomings that would be noticeable to me. For example I don't need video, so if the video is inadequate I don't mind. If there is another camera that you think fits my needs please help me out by directing me there. Thanks in advance.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic