LensRentals recently did a comparison of the leading macro lenses at macro distances, and at least one result was surprising (to them):
"The Sony FE 90mm f/2.8 Macro totally shocked me. It’s clearly better at all frequencies at macro distances. In fact, it’s the highest resolving off all these lenses at macro distances, at least in the image center. I’m not certain if it’s related or just coincidence, but the Sony lens has electronic motors controlling both the focusing and the compensating element."