Food for thought: You can get great closeups with just about any lens, but there is more to a dedicated macro lens than getting close. Canon, and others for that mater, use the term "macro" rather loosely and generally just refers to having a short MFD. Just because it has "Macro" printed on the barrel doesn't mean that it has all the characteristics of a true macro lens. True macro lenses are designed to different standards so they are typically more expensive, the most obvious being 1:1 magnification at MFD, others being internals designed to reduce various distortions when focusing close. Lens profiles can take care of some of the distortion in non-macro lenses, but IMO anything you don't have to do in post is a bonus.
To answer your question, yes, the RF 100mm f/2.8L IS USM is as good as it gets for macro/closeups and currently on sale from Canon at $999 U.S.D. I've been using the 100mm versions, EF and RF, for a very long time. I've used various macro FL's over the years and the 100mm fits my use the best, both hand held run n gun and posed subjects from tripod, including focus stacking.
I have posted lots of examples in the "Share Your Photos" section of this forum. If you buy this lens, it will be with you a long time 🙂
Newton
