Sounds stupid, but I use my iPhone5's camera for small shots. It's actually quite good.
Though, when I REALLY want some macro detail, I'll pull out my Canon Rebel EOS. Mostly, I just use it for taking pictures of coins and then zooming in to see detail (like dates). Using a camera is 10x easier than trying to make it out with a 20x magnifier.
Skippy