Anyone have any models that they can suggest for me to have a read up on?

I'd like it to be relatively small, zoom, 'ok' macro ability and pretty much turn it on, take a photo and turn it back off.

Done a little searching, but the variety is literally staggering.