I used to have the EF 200 2 (for fashion mostly) and sold it to finance the move to MF. I miss that one dearly. I have rented (not owned) the 400 2.8 II for a safari in South Africa and loved it but could never justify buying a big white given how rarely I do wildlife and I don't do sports.
Well these are your words - I haven't searched long past that
So you are happy to assume that about an unannounced Canon lens, as well as assuming that recent Sigma offerings are sub par?
I cannot access your web sites from work, sorry. I can't even access my own portfolio from the office (in my signature, together with the list of my current gear)
I have listed on dpreview my old (and sold) gear and the list is getting too long, I think I may delete it out of shame thinking about all the money I've spent

Personally, I have started with the 350D and as you moved to FF as soon as the 5D

become available - still have fond memories of the old rascal. But in 2017 I branched out to medium format for fashion photography. I use Canon for travel, wildlife and family stuff now, and Hasselblad for fashion... as well as drones occasionally.
I have all 3 and they are great in their own different ways, especially my favorite, the 85 1.2... Sigma is supposed to release a 85 1.2 soon, but obviously it's academic since Canon does not allow 3rd party FF AF lenses for RF. And Sigma has a 35 1.2

which Canon has not deemed to release yet, in their infinite wisdom
The EF 200mm f2.0 LIS is a bit of a unicorn lens for me. Everytime I've had the cash in my bank account, none have been available....then when there's a load on the market and the price drops...I'm skint. However it's probably a lens that will get minimal use, unlike the rest of my kit, which is literally the smallest subset of gear for each of my genre requirements.
Let me exand a little bit further my observations with both Sigma and Canon. A number of years ago, I bought a 120-300/2.8 OS and found it to be overy heavy, fragile, poor sharpness at the long end / wide open. It's OS was like a childs toy and it's AF was so inconsistent I was missing shots. It was no where near 300mm in reality and it focussed breathed so much that it was eclipsed by my ef 70-200mm f2.8 LIS II in every respect except it's raw reach. The Sigma was a massive dissapointment compared to my EF 400mm f2.8 LIS and my EF 70-200 f2.8 LIS II. It went back shortly after purchase. I've had and trialled a lot of Sigma lense in the past and I'd read many times...that was the "old Sigma, you should try the new". Each time i find the same limitations in their design philosphy and with their lenses they are always lacking / dissapointing in some way. Sure, maybe 80-90% but not the full 100% I get from Canon's finest. Now compare that to the new Canon RF 100-300mm f2.8 LIS. It's is one of the sharpest zoom lenses ever made by anyone, reports from testing web sites I trust, replies and comments from friends I know who personally own and use this lens regularly. One observable test of sharpness, is it sharpness wide open on a R5. How does it respond to a 1.4x TC? If it's as percievably sharp with a 1.4x tc on a R5, then the core lens with a 1.4x is out resolving the R5's sensor.
Very few zoom lenses can do this with a 1.4x TC and (from what i've read and heard from friends) the Sigma 300-600mm f4 is noticably soft at 500-600mm @ f4. With a 1.4x TC it's worse and with a 2x it is almost unuseable on a high density sensor.
What really describes a sharp lens, is when you can drop a 2x TC on it, shoot at it's wide open aperture and for the image to still be sharp and outresolves the R5's sensor. The new RF 70-200 f2.8 LIS Z and RF 100-300mm f2.8 LIS are both in that category. They stand untouched by anything that sigma had produced.
In the world of Canon primes, even their latest RF lenses come a bit soft when using 2x TC's. The best of breed are Canon's mk II EF white primes, specifically, the EF 300mm f2.8 LIS II, EF 400mm f2.8 LIS II, EF 600mm f4 LIS II and EF 800mm f5.6 LIS. The Current RF 600mm f4 LIS is rarely used with a 2x, normnally with a 1.4x max and as such it's 2x deficencies are often over looked. The new Canon RF 100-300mm f2.8 LIS is remarkable because it's sharpness bar was set against on of Canon's sharpest lenses ever, the EF 300mm f2.8 LIS II. I know many wild life guys who still use the EF prime with a 2x converter as their 600mm f5.6 and get stunning portfolio worthy results. It's THAT good and this Canon zoom matches the prime's result while adding the versatility of the zoom range.
When I consider the history of Sigma's X-600mm f6.3 lenses, it is easy to predict that Canon's rumoured X-600mm f5.6 will eclipse the Sigma in every metric. It's a reputation that Sigma have built for themselves. The difference is that the Sigma is a consumer orientated optic, where the Canon lens is likely to be a pro spec optic and will develop this lens to the highest level they can produce (and a proportial retail price to suit). The only suprise from Canon was the RF 200-800mm, which is a great lens but boarderline in it's sharpness at 800mm on a R5 and noticably soft on a R7. This has been reported by many users and trustworthy lens test sites, but there's a lot of youtube influencers that seemt to pass over this point. This particular lens is NOT a L lens, although it's painted white. If this new lens is intended for a budget concious market, then it may be very similar to the RF200-800mm lens, but reading the rumours on this site it would appear to be a pre-oriented L lens. If this is the case then Canon will throw their very best tech and specs at this lens.
In terms of Sigma's rising of quality and refinement, I can't see anything in their current portfolio that can compete with my current EF lenses, let alone RF variants.
For me, all of my current EF lenses fit my brief perfectly. My issues with my EF 11-24L is that it is a big lump of glass to lug about..but my word...what a beatuful optic. The RF10-20L is a much more portable proposition, but I loose my filtration options. So I would still need to keep my EF lens when I need it for specialist applications. A bit like TSE or Fisheye lenses.
I hear you about the lack of a RF 35mm f1.2, however...I've never found the need for that extra 1/3 stop on a wide angle. The dept of field effects that I enjoy with my EF 35mm f1.4 II L at close focus, I can't imagine that an extra 1/3 of a stop will be particularly noticable than it is between a 85mm f1.4 / f1.2. It's certainly not a lens I would be personally pining for, although I know this is a sore subject and some guys on here are very vocal about it. I also appreciate that my use shooting case scenario is likely different to others.
Canon were very resistant to the calls fro a great 50mm on the EF mount and now we have many great options on the RF mount...2 L's to choose from plus others!