Hello,
Yes, low-light photography is still tough with digital, even with the best equipment. Keeping noise low and maintaining contrast is difficult. Some newer camers though [both point-n-shoot and DSLR] have really credible 400, 800, and with some even 1600 ISO settings [low noise, good contrast].
As for my images, with my moniotrs, the images I see likely look completley different than what anyone everyone else sees as I manually color balance my monitors [special software and a monitor color meter] thus my images would not have much 'pop' on non-calibrated monitors, they would likely lok a bit washed out.
Because of this [and being limited to displays of 72dpi] I added some 'curves' and color saturation in post.
On my monitros the altered images look a bit artificial but I imagine that they look "OK" on a typical LCD or CRT screen.
As for post in general I try to do as little as possible [levels, a bit of color, curves, and some sharpening] though sometimes an image really needs more attention to shadows and highlights, etc.
Here is one pretty much straight out of the camera [very accurate, likely a little 'dull'].
And the same image with a bit of post-processing [a bit artificial but with more 'pop'].