Here's the gear I typically use for my macro shoots:
OM Systems OM-1 mark 1 camera
OM Systems 90mm Pro macro lens (I mostly use this one)
OM Systems 60mm Pro macro lens (for larger subjects)
Godox v860iii flash (previously used the v350o but upgraded to the v860iii to get more rapid continuous shots and focus bracketing without dropped frames)
AK Diffuser
For managing and processing my photos, I use Macro Studio -- the modern app for doing focus stacking and editing. It produces better results than the other leading apps, has a lot more functionality, and is a one-time purchase vs. a subscription.
I shoot most subjects handheld, but sometimes use a tripod mount in my house. I never kill insects to photograph them. I either shoot them live or find them already deceased.
I shoot a combination of single shots and focus stacking.