I'm not a photographer, by any means... but I am looking to improve and learn some things. I'm wondering if anyone can recommend a good digital camera in the $500 range... hopefully with good zoom settings as well as micro (or is it macro? lol - for small subjects, ie insects, etc.) capabilities. Any brands to avoid? Any brands tried and true?

I'm completely clueless about these things and would hate to spend that much money on a 'dud'... like last time. sigh  I just need something with good clarity and the ability to really capture textures on both large and small objects, basically.

Thanks,
Brandi