I'm a little lost - is the discussion mostly centered on macro/supermacro stills or video?
Video tracking AF and photo AF are quite different animals, and for very few lenses support the super fast advanced AF offered by Sonys when shooting video (mostly G-Master series lenses, like the Sony 90mm).
As a rule, lenses need to be somewhat optimised for video use to be fast enough to AF track efficiently when shooting video - especially at higher framerates.

In general, macro video is mostly shot in manual, unless dealing with a fast moving small critter, where shallow DOF and fast movement mean it becomes very difficult to follow (small critters in blackwater or worse, predatory action fueled bonfire dives for instance). The critter swings in an out of the shallow focal plane, which is more of a problem when shooting a sequence than when freezing an image. This is where fast video tracking AF could really come into play.
Videos of fast moving tiny critters are very rare though, and most out there is super slowed down high-frame rate (120fps) footage, to extend the short moment when the animal or an aesthetically acceptable section of the animal was in focus.

Edited June 19Jun 19 by bghazzal

I'll add an important detail that's often overlooked or simply ignored: when you switch to video mode on cameras, even those famous for their autofocus, the myriad of AF settings are disabled, limited, or at least very different.

Ninety-nine percent of the AF setup tutorials you find online for top-tier cameras forget to mention that those functions only exist for photography.

Sad but true.

After doing tests and watching dozens upon dozens of YouTube videos, I only found one video on the Sony A6700 that had a chapter dedicated to video AF, and it clearly showed that all those super cool functions just explained are not available in video mode.

Additionally, as Ben says, the user experience of autofocus is directly tied to the lens being used.

@Davide DB Unfortunately, that is very true.