I've pretty much resorted to having to use the flash anytime I'm indoors, bright lights or not. Otherwise the pics are mush. I will say though, I do like the results when using the built in effects, like the cross-processing. Really livens the pics up. Without any editing afterwards, the pictures are really poor. I've yet to see any pics from a Nexus that make me say 'wow'. They're all kind of blah. It seems like Gizmodo gave the most accurate camera review/comparison between all the current smart phones.
Here's a few edited pics that I actually liked. The ones in portrait orientation appear squashed, so click on them for original size.
My first take with a test of colors. Seems pretty good maybe a bit more washed out and slightly less detailed than my X2. These are both without the flash on.