Lens rentals compares various macro lenses from different manufacturers,, and is particularly impressed with the Sony 90mm FE lens.
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. As best I know, all of the other macro lenses tested have mechanical movements of the compensating elements.
(Warning, it's a very geeky article!)