@JTM-77,
This thread was started with a user asking which Tamron/Sigma 150~600 (EF Mount) for his R6? Suggestions were made. Performance and limitations pointed out. Typically someone looking to do bird and wildlife might use a 150-600 which we all know are EF. Some get by with shorter FL's. Later someone suggested the RF 100~400. Points regarding its performance and possible limitations were added. While its reach is shorter, the OP indicated it was acceptable to him. He grabbed one.
Now you're asking me about my gear. Why do I have both the RF 100~400 and 100~500? Which doesn't seem relevant but its for
travel. I don't always need or want to pack my 100~500. The lens you said earlier, "wasn't that good". The 100~400 is a lighter weight alternative and in many situations has the reach and clarity I need for most shooting conditions. Landscape and architecture is my primary focus. If you read my sig, you would see I have FL's covered from 15~500mm (RF Trinity+). I'm not here to argue. If you don't like the 100~500 that's fine. Its been a great lens for me and others based on what I've seen.
@killswitch I'm glad you got a lens that fit your budget and works well for you.