The King is dead? Long live the King!
Ring USM was all about performance in the context of photography, manufacturing at scale, and reliability. Anything that replaces it with rock solid performance that can be achieved at quantity and be occasionally hit against a rock is equally a good solution. It looks like VCM is increasingly carrying the torch.
From a personal opinion standpoint, I dislike anything that can break when twisted and the power is off. So for the way some gear drives have been implemented I tend to avoid them in any brand's makeup.
But looking at the EF lens catalog, many of the initial offerings were limited in their drive capability. I stopped counting at 41, but glancing ahead on the page more than 41 EF lenses used gear or PZ or other drives. I don't think RF is doing anything different here in terms of equivalency. I think that where the RF lens stable is avoiding high performance drives in the 2020s is surprising to me, but Canon must have its reasons.
Of course, I only own USM EF lenses — save for the 40mm 2.8 STM — because I have other tools or remote / external mics for video. So I don't care if they're a little noisy — I care that they're responsive for their purpose. Also, while some USM lenses moved enough glass to be slow as compared to many, for typical use cases they AF just fine (the 50mm 1.2 is a typical portrait lens, for example, not an F1 straightway snapper — my peeps just don't move in a blurring motion; even the kids aren't that fast).
USM, VCM, whatever. Just be fast, reliable, and tough. Oh, and Canon — please stop releasing $2.5k+ lenses without focus rings. The sports folks might not care, but some of the rest of us do.

Not that my opinion matters here.

A 200-800 lens without a dedicated focus ring is, well, just silly. In my opinion, of course.