To capture better low light photos requires:

(1) low-noise camera design, and
(2) LARGER photo capture-sites on the imaging chip.

This generally means a LARGER imaging chip.
Pretty much all non-SLR digicams use fingernail-sized chips.
Pretty much all SLR digicams use imaging chips that have 4-8x the capture area of the smaller ones.

Eg. A Canon EOS-10D/DRebel SLR captures photos at ISO800 that are as good as ISO100 photos from many smaller digicams.

Cheers