I just bought a new compact point-and-shoot digital: Fujifilm Finepix F30. I chose this one for it's low light capabilities, and I am not disappointed. In fact I'm absolutely amazed!!
Here is a shot I took at ISO 3200, yes 3200!!, in very low lighting. First shot is unprocessed (by me), except for resize to 800x600. The second had a bit of processing: median filter, resize, sharpening. Yes, an ISO 3200 image from a compact digital (and I mean compact!) could still take a bit of sharpening.
I'll post some more pics a bit later.
ps. that's aperture: f/2.8, exposure: 1/8s.