I have a Canon PowerShot A40. It is only a 2 megapixel but it was all I could afford at the time. I'd definitely like to upgrade to at least a 5MP, but that is way out of my league right now.
The key component to a focused macro is a tripod. Not one of your typical standard sized ones; I'm referring to a minnie one that wouldn't even be noticeable to your pack weight. That would serve the purpose for low ground shots. As for something waist height, I was thinking maybe one could rig their hiking poles to possibly serve as a temp tripod. As I don't own a pair of poles yet, I haven't been able to test this theory out. I'm sure it would take some creativity, but believe it could be done.
There are actually special macro lenses you can buy for your camera. I'm fortunate enough to have a camera that is capable of changing lenses; but not fortunate enough to own a macro lense yet.
I remember a fellow posted, on a photo site, about how he made a homemade macro lense by using a magnifying glass and somehow securing it to his camera. By searching the website I'm sure you may come across others who have posted just how to achieve this sort of thing.
Now you got me wanting to go out and try this. Thanks for the inspiration
Live in each season as it passes; breathe the air, drink the drink, taste the fruit.
~~Henry David Thoreau~~