I have only manually focus stacked, but i can say the sony a7riii beats the pants of my sony a77ii 24mp crop in detail, noise ( even at 100 iso and good lighting), and I feel like I have to take less pictures with more megapixels to get the same quality results. I also believe moving the camera body to move the focus plain, instead of changing the focus of the lens. Leads to better less distorted images because of focus breathing.
I am by no means an expert in macro photography and only mess around for fun. I encourage you to fact check the part about moving the camera vs focusing the lens. I want to say I saw it on a B and H class on youtube.