I need your help

I am in the process of buying a digital camera (before you say anything I keep telling you I am well behind the times….). Any suggestions? Any recommendations? I don’t want supa-dupa expensive or cheap and nasty but something in the middle. I just want a camera which aims and shoots.
At the moment I am using my dependable rinky dinky compact “state of the art” Motorola mobile phone to take pics. Anyone who is able to guide my virtual self through the pitfalls and complexities of buying a digital camera will be appreciated. It is probably dead easy but I am …crap at this sort of thing and this is from someone who used to read T3 (Tomorrow’s Technology Today) magazine!

So please, help a comrade out.