Some time ago, I was solidly in the 'get native glass' camp.
Now, I'm not so sure. I've had the opportunity to work with the likes of Sigma, Zeiss, Tamron, Laowa, Voigtlander and Viltrox (to name a few) over the past several years. Many are manual focus and it's not been an issue. And I've been slowly relying less and less on all the automatic and 'priority' modes of my gear. My attitude has more often been 'Set it to full manual' and see what happens. I think doing so connects you a lot more closely to your photography and forces you to slow down, consider context, framing, light and so on.
And can any of us look at two pictures and honestly chose the one that was taken with the 'cheap' lens? I know I can't.
Finally, consider this before you buy your next lens.
And I've been slowly relying less and less on all the automatic and 'priority' modes of my gear. My attitude has more often been 'Set it to full manual' and see what happens. I think doing so connects you a lot more closely to your photography and forces you to slow down
Coming from the Film Days, I absolutely don't care how many frames per second I can shoot, because each shot cost money to develop.
Auto ISO in Fv mode is about as "Auto" as I get. I did try High Speed once for about 3 seconds. Nope, not for me. Albeit I do use features like Multiple Exposure, HDR Mode, Focus Bracketing and even IBIS High Resolution (once in a while).
Not macro but was at a horse show recently and a photographic buddy was there. I was using my 70/200 2.8 go to equine lens.
Buddy said hey ya wanna try a sigma something zoom lens photos were to me me at least on a par no complaints but auto focus particularly eye focus was woeful.
Doesnt really help your macro question.
Edit so static images no issues in quality