Came across this: https://phillipreeve.net/blog/adapters-manual-lenses-sony-a7-series-guide/Bought a Sigma mc-11. Put IT on an A9ii. Sigma Art 28 f/1.4 works well on photo and video.
Art 40 f/1.4 works only on photo with autofocus.
Tested other lenses I have ; EF 35 f/1.4 L ii, EF 40 f/2.8, EF 24-70 f/1.4 L is, 16-35 f/1.4 L is, 28-300 L is, and Tokina Opera f/1.4 all of them had working autofocus with photo. Not all functions. But not with video, You have to use manual focus.
Ordered a 7Artisan to try.
Would also try Tokina adapter, but no one could deliver.
The last one that I consider was K&F concept.
Sigma mc-11 has a good build quality and got a gasket.
which maybe of interest but does not include the Sigma.