The Sony FE 90mm macro was released in early 2015 so is a bit old compared to current macro lenses for mirrorless cameras from Canon, Nikon, Sigma and others. Lens development has changed dramatically since 2015 but the 90mm still holds it own on many levels.
The new Sigma looks excellent and has some upsides with a lower cost, the ability to be used with tele converters up to X2 and excellent image quality. It is however a bit slower than the Sony 90mm.
I have tired the Canon 100mm macro IS with Sigma and Metabones adapters on Sony A7R IV and A1 and unlike Backscatter I found no noticeable difference on A7R IV and the 90 was clearly faster on A1. When I first started using the 90mm on A7 II and A7R II I used focus limiting because the lens hunted less. As the camera bodies improved I moved to focusing through the full range unless I set out to do nothing but 1:1 or greate macror. I also agree with Jim Decker's (Backscatter) statement that the Sony 90mmm macro matted with the Sony A1 camera is the best macro I have ever used and between use we have used a bunch.
One of the best tests of macro lenses auto focusing underwater is blackwater diving where everything is in motion including the diver, camera and subject. The two attached photos where taken on blackwater dives using the Sony A7R III and A1 with the 90mm macro. The Zoea, larval stage crab was taken in the Philippines with the A7R III. The constantly moving Juvenile Tuna (about three inches/76mm) was taken off Palm Beach, Florida using AF-C and focus area tracking spot which acquired the head and eye instantly. I also use the 1/400th shutter speed for blackwater and see a noticeable difference over 1/250th sec. You would think that on a night dive miles off shore that the water would be black to begin with but I find far more purple tint with the 1/250th over the 1/400th speed.

