In my room which is quite dim with some lighting a lot of cameras don't seem to like very well (except my Nikon which is obviously going to be higher grade) it doesn't take a great picture, there's a lot of grain. I think this is more because you can't adjust any of the settings to combat this. It's a good little camera otherwise.
Due to the form factor of it, I don't see myself using it unless I want to snap something when I'm in say, a coffee joint, a train or sitting on my sofa and one of my pets does something stupid. If I have the iPad in my hand I'll use it to take a picture, but for everything else I'd just get my phone or real camera out. (my iPad takes a nicer photo than my Nexus S' 5MP camera, it should be noted)