I started DSLR shooting with a bag of pre-owned Canon kit that included a Tokina 100mm f/2.8 AT-X macro lens. Because hand-held close-range shooting soon became quite important to me, I added a Canon EF 100mm f/2.8L Macro IS, the "IS" referring to Image Stabilization, Canon's term for vibration reduction/control. Many will say that VC/VR/IS is useless for close-range and macro shooting, but I find it very useful. I shoot evidentiary/forensic/crime scene images while on duty; sometimes, a tripod simply cannot be erected where I must shoot.*
My wife was one of the most-experienced forensic/crime scene photographers in the USA, before her retirement in 2015. She mentored me as I started SLR shooting, and some of the lessons, after I understood the basics of photography, were photographing fingerprints on glass surfaces, hand-held, with a Tamron zoom lens that was not truly a "macro" lens, but was the lens issued to her by her employer, and is quite decent for close-range shooting, if not true macro.
The Tokina 100mm macro lens made such close-range shooting easier, but it was the Canon 100mm Macro, with Image Stabilization, that truly helped my hand-held macro and close-range shooting. If you buy a Tamron macro, I believe that you will find the version with Vibration Reduction to be useful. Even if you mostly use a tripod for macro shooting, which makes VC unnecessary at such times, a macro lens doubles as a quite good telephoto lens for other subjects, for which VC will be an asset.
To be clear, the manufacturer is not an issue on this regard; most likely, every current/recent micro/macro lens in the 90mm to 105mm range is going to be very, very good. My micro/macro lenses were made by Tokina, Canon, Nikon, and Voigtlander. One of my local instructors, Christopher Duncan, who has authored successful books on crime scene photography, compared Canon and Sigma, and bought the Sigma, with his own money, no sponsorship involved.
One tip: When shooting macro hand-held, do not be afraid to set the AF lever to the "C" position, even though you are shooting a subject that is not moving. Your own involuntary movements can cause apparent subject motion, as your sensor sees it. AF-C allows the AF to continue to track this apparent motion during the process of capturing the image.
*I am not claiming to be any kind of expert.

Having started serious photography in my middle years, after my eyesight started deteriorating, my achievements will, likely, remain modest, but I still like to share what I have learned.