There is a broad appeal to this lens: it is quite affordable, it has a long reach, and it produces very fine images.
Due to its low weight and good weight distribution, handling is superb: holding/carrying a R5 by its grip with an attached RF100-400 is no problem at all (especially when using a Peak Design clutch or similar).
Image quality (contrast, sharpness and color rendition) is very good, and for most situations, one would be hard pressed to find a fault in the resulting photos.
Admittedly this lens needs some light in order to shine - it would not be my first choice for shooting fast action indoors.