Well, after reading all those links to the 7800X3D review, I'll just say that it's poorly balanced. When I look at a fairly common resolution for higher end gaming, 1440p, it's a whopping 2.8% faster than a 13900K. And that's if you fork up for a 4090.
By contrast, when you look at most of the productivity scenarios that same 7800X3D is getting walloped by much cheaper CPUs and demolished by similar priced ones. Many situations where the difference is in the vicinity of 20%. And they're not edge cases, java for example a 12700K beats the PBO'd 7800X3D. Java is used all over the place. Any kind of development, database, modelling / science software - this is a chip that often performs alongside Zen 3.
So yeah, if the *only* thing you are concerned with is gaming *and* you have a 4090, then the 7800X3D is an easy win.
But I don't really think there are many people around who actually have that use case. Even hard core gamers like to do other things.
IMO it's not worth it to sacrifice double-digits % performance on multiple productivity use cases to get a paltry 2.8% FPS bump at 1440P with a 4090. These are just one trick pony chips, interesting yes but there's a huge trade-off.