>>3438389I would skip the adapters and such unless you're going to grab some microscope stuff.
Best macro equipment for the usual subjects (bugs, flowers, etc, not truly microscopic) would be a high resolution dslr and the appropriate lenses.
I use and I'm fairly satisfied with
Canon 5ds
Canon 100 L macro (for up to 1:1 work)
Canon Mp-e 65 (for 1:1 to 5:1 work)
Laowa 15 (wide angle 1:1, kinda of a super goofy lens)
focusing rails
alienbees 800 lights
sturdy tripod
All of my work is in studio so portability doesn't matter to me.
The laowa you have in the op image is a weird specialty lens that is really set up for video. You would be better off starting off with a more general purpose 1:1 macro lens and a set of extension tubes.. Depending what your shooting and why you could very well by a twin-lite or ring light for your macro lens. They give good even if generic light.
Macro lenses by any of the big brands are generally well regarded.
