I have long thought about a replacement for my Tamron 200-500 with a switch to mirrorless in mind, The options grow and grow, but today I ordered a used EF 100-400 II and I hope that I will not regret it. It always seemed tempting to me to get a longer reach, but most of the other options do not really have a great sharpness at the long end. It seems unwise to invest money into a lens that came out in 2014 and has a shorter reach than my Tamron, but only other options that surpass that lens in sharpness and overall image quality would be the RF 100-500 for 3099 Euros that would not work on my DLSR or the very expensive 200-400 with the built in 1.4x converter, which is very heavy and expensive. I am glad that Canon expands the range of tele zoom lenses into a cheaper segment, but I am wonder how much image quality will be compromised. Can the much better IS compensate for that? In a few days I will know more. That is the first used lens I ever bought and that old used lens should give me the resolution for a bright mirrorless future.
I think for an R6 with 20 megapixels lenses like the RF 100-400, RF 600, RF 800 and this new lens might be okay, but they could lead to a lot of frustration on a higher megapixel camera or a crop camera.