When it comes to macro photography, one of the most important pieces of equipment is the lens. The best lenses for macro photography will depend on your particular needs and style.
Generally speaking, you should look for lenses that have a good focal length range and wide aperture settings. Macro lenses with a longer focal length are great for capturing more distant subjects, while those with wider apertures are better for maximizing depth-of-field and allowing more light in when shooting in low light conditions.
Additionally, having tripod stability is essential for getting clear and sharp images, as well as utilizing focus stacking techniques. All of this will ensure that you get the highest quality shots when shooting macro photos with a mirrorless camera.