Can’t answer your question sorry but would also be interested to hear from anyone who uses this lens for macro and insect close ups
I did consider getting this lens when the focus packed up on my my EF 100L but reading reviews one or two people mentioned that the RF 100 as a factor of its design as it can focus closer than the EF version, does has a degree of focus shift, this put me off
but wasn’t able to find anything definitive as nobody I know has the RF version
In the end I got my EF lens repaired