A great article overall, and I think Canon Rumours is a great place to centralize material such as this. Canon's technical archives are the source of truth, of course, but this is convenient and fun.
Personally, I find that even with the amazing AF capabilities in today's R series cameras I still find myself using manual override at rodeos, marshes, wheat fields, etc. I've kept my EF lens stable as a result, and as much as I do appreciate the RF lenses for many factors I simply cannot justify to myself plunking down $1-$6k on anything that does not offer manual focus override without first needing to hit a power button after a moment. Plenty of other toys to get instead. The EF lenses at the L tier are plenty fine for many modern photos, and instant manual is awesome. It really sucked to see RF lens focusing tech partially step back to 1987 when the lenses were first released. If instant manual override returned to the RF line without the need to wake the camera up I would very much seriously consider a lens replacement spree. For now, every so often a Canadian retailer offers stuff like the 50mm f/1.2 for 50% off due to overstock. Unless someone needs the latest and greatest for what they do, it's hard to beat those kinds of deals.
On the other hand, I haven't really turned the ring on many RF lenses this last year. Maybe someone here has and can pleasantly surprise me with a, "hey, check out the XYZ -- it works just like the EF XYZ L USM but sharper, faster, more rainbow-y and also manual MFs with a twist and a dead battery" remark.
But, no doubt, purely from an engineering nerd perspective the advancements are cool!