New EOS R7 User hunting for the best macro lens

[LoveWeims]

I have a new Canon EOS R7 and I love macro photography.  Although tempted by the lower price of the RF35MM F1,8 IS Macro STM lens, I am not sure I want to be THAT close to my subjects.  I am looking at the RF 100mm F2.8L Macro and wondering if it is the preferred mid-range (haha) lens.  Please note I am also learning about the many ways the settings can screw up the focus but that's a whole other issue assuming this higher priced lens is actually a good one.

[kvbarkley]

What are your subjects?

Not made any more, but the EF-S 60mm macro was a good compromise, and may be found used.

[LoveWeims]

Dragonflies, interesting bugs, and other small nonslithery creatures

[kvbarkley]

Taken with my EF-S 60mm macro