equipment recommendation - What's a relatively low priced camera that performs well in low light condition?

I'm looking to buy a new (digital?) camera for regular photo-taking. I'm not an enthusiast and know next to nothing about photography. I would like the camera to be relatively low priced (for example, think under $300 in 2012), good in low-light conditions and able to produce good photos. I'm not experienced with manual modes so I would like it to be able to take good photos on auto.