We often read that macro lenses need to be long to provide a sufficient working distance. Recommended Sony 90mm macro lens (which I also have). But it is difficult. 90% of the time I need a macro, I use the Zeiss 50mm Touit. Its working distance is sufficient, it is light and compact. And the picture quality is amazing!
Nikon 35mm f/1.8G Auto Focus Lens for Nikon DSLR Cameras - Black (Model 2183)
125 Review
Canon EF 50mm f/1.8 II Fixed Lens - Discontinued by Manufacturer
93 Review
Nikon 50mm f/1.8D Lens: Perfect for Nikon DSLR Cameras!
97 Review
π· Nikon AF-S NIKKOR 50mm f/1.4G Lens with Auto Focus: Perfect for Nikon DSLR Cameras
76 Review