Following the blurb about the lack of macro lenses for the Sony E-Mount especially when it comes to black water diving I have looked into this myself.
Based on technical lens design the following lens will work well in blackwater
Canon EF-S35mm f/2.8 MACRO IS STM - ASPC DISCONTINUED
Nikkor AF-S Mirco Nikkor 60mm 2.8 EGD - Full Frame - DISCONTINUED
Nikon AF-S DX Micro Nikkor 40mm F2.8 - APSC
Nikon AF-S DX Micro 85mm 2.8 - APSC
Olympus 30mm f/3.5 macro - MFT
I do not have data for the Panasonic 30mm macro but I think it will work well too as I have the lens
You notice a few things
1. The focal length is short so those lenses have a wider field of view of other macro lenses
2. Most lenses are quite old. The Nikon are over 15 years old the MFT are at leat 7 years old
In conclusion most options are for APSC and MFT users. Only Nikon has a 60mm lens that is adequate on FX however the lenses are discontinued. Canon does not have a full frame lens with limited focus breathing
Looking at the RF line the 100mm is better than previous lenses however I am told there are other issues with it
What needs to happen for the E-Mount but also for other mirrorless system is to have lenses such as those above. As of today other than MFT the options don't exist in any mirrorless full frame mount
I would be interested to hear from users of the above. I have done a few checks and coincidentally I have found matching for all except MFT and I think the reason is that even if the lens does not breathe Olympus live view makes the shooting impossible
So right now blackwater should be a Nikon DSLR (Mostly APSC) and Canon APSC story keen to hear if my theory holds