I rented the RF100 2.8 macro to see if it's something I want to put in my bag.
....and I do...I do.....
What's a kidney worth these days?
(EOS R5 RF100 f2.8 1/250 f5 ISO 100)
That is one one my wish list as well. For now I enjoy the original non IS EF 100mm macro. Used around $300-400. But if you have the budget the RF has the advantage. Stopped down to 5,6 they are pretty comparable.
So far I'm liking this lens a lot, but I concur with the reviews I've read - the "Spherical Aberration" Control thing is a gimmick I didn't ask for and would never use. Pretty sure I've never said "Y'know....this lens is just too sharp..."