Low light ability is relative - while some P&S cameras are better than others, and some can approach usable, in the greater scheme they're all quite poor. The sensors in P&S cameras are just too tiny to pull in enough light, and the lenses to miniscule. For true low light ability, you have to go bigger camera, bigger sensor. There has to be some reason so many people are wandering around with those huge DSLRs nowadays, right?
Like anything else, the best is almost never going to be the smallest and cheapest.
What precisely you need to be able to do in low light is a big factor...and how low of light you are talking about. Some of the above P&S cameras are better than ones from 2-3 years ago, but will still not do well if you need to raise the ISO to over 400, shooting handheld at night with no flash, shooting a running child indoors in a large room with a 40W lamp, and so on. Most of this will simply be impossible with a P&S, for anything other than tiny album prints or small TV display, if that. For this type of stuff, you need to seriously consider getting into a mirrorless camera or a DSLR.
However, there are SOME situations where a P&S camera can use some tricks to go beyond their competition a bit in some low light situations. For example, there are a few P&S cameras that use slightly larger sensors, like the Canon S95, Panasonic LX5, and Olympus ZX-1. They also have 'fast' lenses with F1.8 to F2 maximum apertures. These will do much better than most P&S for low light movement/action, like trying to photograph people indoors or moving subjects in low light. Still far from what a DSLR or mirrorless can do, but better than most any P&S. But note these cameras don't come in 'superzoom' varieties - they usually have very limited zoom range.
Another trick some cameras have will allow even small sensors and superzooms to shoot in very low light with great results...assuming you aren't trying to shoot something moving. You can shoot scenics, landscapes, buildings, even a person standing still for a portrait...but not anything moving quickly. If this type of scene is what you usually shoot, then look into cameras that have 'multistack' capabilities, mostly pioneered by Sony and in many of their models. A comparable superzoom camera that recently came out with this feature is the Sony HX100V...which compares well to the Canon SX. If you don't need as much zoom, a travel zoom pocketable cam version is the HX9V. The mode is called 'hand-held twilight' and it will allow the camera to raise the ISO up to 3200 - which is NOT advisable in a small sensor P&S - but will shoot 6 frames with one button press, in about 1/2 second. The camera automatically merges all 6 photos into one, aligning them and using the stacking to restore detail and eliminate noise (noise is random and appears in different places in each frame - so by combining 6 frames, each frame has different areas of the photo that are noise free - all 6 frames are enough to basically eliminate noise). The results can match lower end DSLRs and far exceed any P&S camera without this feature. But it cannot be used on moving subjects.
Here's a quick example of using this feature - this was with an ultracompact credit-card camera with the smallest sensor size and a slow F3.5 lens, handheld in an extremely dark room, at ISO3200:
ISO3200 is basically worthless and useless on P&S cameras - and had I tried to use ISo3200 in normal mode, it would look like a mushy watercolor painting. Use the multistack mode, and you can make out the hair detail on the cat in a dark room. It's truly amazing - if more static types of scenes are what you'll need it for.
Hope that helps a bit.
