The technology filtering down to consumer level in a couple of years is pretty exciting, though as elithrar noted, the exposure is going to be difficult as it's hard to tell between "dark area you want to see" and "dark area that's the background".
You'd be surprised how clean some of these things are, especially so if you don't plan on blowing things up big. Plus, with NR software these days, you can easily get usable 12,800 ISO & 25,600 ISO shots if you expose them well.
The real trick to shooting in low-light is nailing the exposure; too dark and you'll have dirty highlights, too light and you'll have blotchy, noisy shadows.
What this has primarily done for me is to make non-studio flash for fill and separation, depending on the situation - to control the subject to ambient ratio, in other words. I do still use it for other routine work, but only where it makes the resulting shot easier to take and get a high-quality result.