Point'n'shoot cameras are cheaper and more convenient because you don't have to buy (and change between) multiple lenses. However, they have smaller sensors that take pictures that are blurrier and have more noise (film grain) then a DSLR would have.
There are some really nice bridge cameras (not quite point'n'shoot, but not a DSLR either) that take decent pictures and have astounding zoom lenses; but generally for low light shots, while they outdo the small point'n'shoots, they don't do as well as a DSLR.
Here is a site that has a good parametric camera search: http://www.dpreview.com/products/search/cameras
If you're needing good low light performance, you would be looking at the ISO speed. Do a parametric search for ISO speed on the site I listed above, and set your range to something like 800 - 25,600. I got 21 results with that search. Most cameras are limited to ~ISO 3,200, so a camera that can go to 25,600 should have super excellent low light shooting ability.
I hope that answers your question adequately!