I like the idea of divisions....
But, at least to my eye, the rankings would be 1) 24-105 f/2.8....2) 100-300 f/2.8; 3) likely the 10-20.
Even on the consumer level, the R50 looks to be amazing, then the R8, I'd probably rank the 200-800....but just above the EFS 10-18.
I say this with a RF 200-800 sitting behind me (arrived Friday). I am still forming my impressions, but the RF 24-105 f/2.8 wowed me instantly. The 200-800, I am debating. It is a good capable lens, but does it fit in my kit? How often will I want to take it out? I am not even 100% sure the numbers you talk about are there. The RF 100-400 is a very capable lens to pair with a general zoom. You really have to want the 200-800. I expect the 200-800 to displace a number of 100-400s and 100-500s among birders, but pair those with a 1.4tc, and you are talking about something more portable, more flexible, better at their native range, etc. So, popular yes, but I do not expect it to displace all the 100-500s even among birders.