Macro photography is one of my favorite styles of shooting photos.
Sometimes the subject becomes almost abstract when it has been zoomed in on. Often the textures become the main focus and a simple object is seen in a new way.
I use a 90mm Tamron Macro lens for most of this type of work.
It is a clear, sharp lens that offers just what I need for macro images. It also works great as an overall lens, but since it is a prime lens and not a zoom, I myself need to do the moving around sometimes instead of just zooming with a lens. So it can be limiting at times.