Secrets to good macro photography

As I remember from reading years ago with smaller matrixes dof is bigger while quality is worse, so it’s easier to use auto focus as you can’t see much difference if it’s focused 3mm further or closer. Plus from experience it’s hardly can focus anywhere near needed point in many situations.
To represent this I take similary-positioned hoverflies, in 1 somehow both abdomen and legs are in focus (also shot with zoom, so dof is even bigger), in 2 it’s far from that, that is also why stacking is so valued in macro.