Regarding low-light photography, as long as (1) your subject isn't moving and (2) you have a stable platform for your camera (ie. you're not hand-holding your camera), pretty much *any* camera can do good low-light photography.
For example, if you're taking a nighttime photo of Cinderella's Castle, and you have either a tripod or put your camera on top of a trash can, you can get a good, sharp nighttime photo.
The HUGE challenge, though, is low-light photography with moving subjects (like taking photos on Pirates of the Caribbean or the night time parades) or hand-holding your camera for low-light photography. These are pretty challenging photography situations, even for dSLRs, so I'd image they'd be even *more* difficult for point-and-shoot / super-zoom / bridge cameras.
I just time my shots to other people's flashes