I’ve looked into getting a Sony and as part of that also into the Macro Glass so maybe I can help a bit. With that said I’m no macro specialist either.
To give you a bit of context, this is probably still my best macro shot and it didn’t even involve a macro lens.
If the lens is exclusively used for macro, auto focus is probably irrelevant.
The Sony is more than sharp enough even on a A7rIII. The stabilization is clearly better than the Tamron Macro Lens I use on my Nikon. I like it mainly because it helps stabilizing the Viewfinder for Handheld macro shots. I usually use a Flash for Macros, but for available light the stabilization also helps by allowing longer shutter speeds. On a tripod it’s obviously going to be useless.
I haven’t had a chance to try to Laowa or Cosina/Voigtlander so all I have to go on is second hand information.
If I understood it correctly the Voiglander does have a distance encoder so the camera stabilization works in all 5 axis. It’s probably not as good as the lens (+ sensor) stabilization of the Sony though. The 0.5x magnification puts it somewhere in between a regular Lens and a (1:1) Macro. Enough for most food and flowers, definitely limiting for smaller insects.
From what I could find the Laowa does not transmit any information to the body so the camera stabilization will likely be more limited (it doesn’t know the distance to the subject) and require manually entering the focal length in the menu. The 2:1 macro can be fun, but can also be achieved using extension rings on the others.
The biggest benefit of the manual lenses in my book is that they are both better corrected for longitudinal chromatic aberrations/bokeh fringing.
If I’d do handheld available light macro the stabilization of the Sony is something to consider, as is the AF for general purpose use.
If it’s all macro in controlled conditions shot with a tripod I’d be very temped to get the Laowa.
Most of my macro shots are captured outside and with a flash so I’m still undecided myself.
The Voigtlander is definitely tempting but I look at it more as a nice manual short tele with can focus a bit closer than usual.