Putting in my $0.02 as well.
Having been able to use both and multiple sony cameras before buying my own, simplified:
1. There is one version of the MC-11 for the sony. They have a version that works better with the sigma lenses that you have for sony and the other that works well for everything else however, its not a big enough difference (this is all in my opinion) to get both. I find it good enough to just get the canon one which works fine with the canon/sigma setups. However do know that if you are completely switching over, sigma has a plan that you can send in your sigma lens, pay a lower fee and they will send you the same lens but for the other mount which would be far better than the adapter.
2. Having adapters will always have focusing issues as you are introducing a "middleman" into the focusing equation. It really depends what you shoot. If you need servo/continues focusing, using an adapter will not be your friend, but portraits, landscapes, etc that dont move much, itll be perfectly fine and work as long as its not in very low light. These adapters dont do too well in low light due to that middleman issue. Remember, the camera has to tell the adapter where to focus, then the adapter has to translate it to the lens, by then, the focus is already off a bit if moving.
You wont be able to beat native even with 3rd party lenses BUT 3rd party (Sigma, tamron, etc) do get really close. I havent had an issue with 3rd party to where I NEED a sony lens.
Though I do have the metabones adapter after trying a few, that I use for my canon 85mm 1.8 and 70-200mm. The adapters work best with good lenses. Typically, L lenses or primes.
Hope this makes sense and helps.
Best of luck
Oh and most of my testing was done with a A7Rii and a7riii.