For most macro offers another world down at your feet, you be shocked at the wonderful world at ground level, if you willing to hit the deck one of the most stunning subjects to photography is fungi, the fine details and the wide range you may find will keep you photographing for weeks on end.
My moth photography is garden based using a live trap, moths are then let out on the gazebo, they are never chilled and has taken months to work out ways to work with them so I can photograph them naturally, Due to the Cambridgeshire Fens countryside and the over farming issues I wanted to see the range of moths and amounts our struggling countryside has. My database if based in Leverington Cambridgeshire and so far I'm seeing a good range of moths.
The Odonata (dragonflies & damselflies) are much harder to find so tend to photograph when possible and with the flowers those are just to keep my eye in throughout the year.
Butterflies are one of the major concerns in the UK, they are struggling badly and again it'd due to farming. the UK government are slowly waking up to the issues surrounding nature. I just hope it's not too late.