I have an aging Sony DSC P150 at the moment which is OK for my general usage - mostly holiday and family snaps - but it's terrible in low light (possibly user error, I'll admit), the battery no longer holds a good charge and the screen is tiny compared to most modern compact cameras so I'm thinking of getting something new. I really haven't kept up with the market (in fact I don't think I've looked at a camera since I bought the P150 in 2005).
I don't particularly know what I'm doing but I do dabble with the settings on my P150 every now and again so I don't want a totally dumb camera, though it would be nice to be able to trust it to take a decent picture without playing with the settings, particularly for when my wife wants to use it as she only really wants something that's point and shoot. Similarly it would be nice if it could take a decent quality video now and again (especially since the birth of malfunction jnr ~6 months ago).
Budget is somewhat negotiable; I'm assuming anything less than £150 is basically junk. The RX100 is tempting @ ~£370 but is probably way more camera than I need and also more than I'd ideally spend though I am somewhat flexible on budget if it's really really worth it.
Thoughts?