So, if you want to go deeper… I think canon does have some focus bracketing with their macro lenses. But those are crazy pricey and you don’t necessarily need them. I use lenses from laowa that on canon mirrorless bodies are fully manual but give me 2x magnification and much lighter weight. The other thing you need as mentioned is light. An on-body flash with a fast recycle time and well placed diffusion will give you great shots (check out the AK diffuser).

You can even get good hand-held focus stacking results with a fast flash and a bit of practice.

Good luck! It’s an addicting and rewarding hobby.