I run a A6500 and got myself both a Sony 90mm 2.8 Macro and Canon 60mm 2.8 EF-S Marco with an adapter for it.
Due to Covid my underwater experience with either has been limited however.... From topside I can report the Canon 60mm 2.8 is easier to use, and the 90mm has a longer curve to get used to, but both very good lenses..
There is also a good price benefit of the 60mm in that is can usually be picked up 2nd hand and due to it not needing any zoom complications works with cheapo adapters, I use my MC-11 on my Tokina 10-17 and a Fotodiox adapter on my Canon 60mm macro and doesn't seem to affect the performance.
I originally looked at the Sony 50mm and there weren't that many positive reviews compared to the Canon 60mm. It fits my housing, although is only Autofocus, but with back button focus and the usual techniques works fine on my limited beneath the waves.
The 16-50mm with wet lenses also works and actually better than expected, but with limitations. I used it for my first trips with the camera and found it acceptable but really not a huge step up from a good compact set up. The dedicated lenses are.