The answer is Sony R1.
But it costs $990.
Your question is too broad.
The answer will be different depending upon the price range, camera size, optical zoom, and features wanted.
All digital cameras that also have manual controls can take excellent night and indoor shots when you use a tripod.
For people who want to take photos (without flash and without tripod) in low light are going to be disappointed.
The newer Fujifilm cameras with the Fujifilm Super CCD will perform best, but still probably not up to your expectations.
If you've read my recent posts, I have a lot of questions that I'm getting out all out once. What's the best camera for indoor and/or night shots, excluding DSLR's since they're too expensive for me.