I do own a 7800X3D and your pick of games appears to favor the X3Ds more than it "should"... that might be a subjective opinion ofcourse.
Not that the X3Ds aren't better in many games, just that in those you picked, their % difference is greater than in others.
I'm not saying you did it intentionally, maybe 9 games is too small of a sample in my eyes...BUT
If you choose something like Factorio (that performs superbly on X3Ds) then you could also put in a title that favors the intels... don't know, Starfield maybe?
Obviously, there's limited time to test every game around, so I understand.
Keep up the good work!
Factorio and Minecraft (and Flight Simulator) are interesting cases of games where there's tons of CPU work in a different format than what you might see in a typical FPS game. Factorio incidentally isn't in the overall average — it's just a curiosity.
Honestly, I still don't really know why Flight Simulator likes the big L3 caches so much. Obviously it's a game that can be CPU limited, in ways that a lot of other games are not. I suspect there's some weird stuff in the engine code that just responds well to X3D.
The difficulty comes in trying to extrapolate the results shown here to other games and future games. Things that are GPU limited (lots of ray tracing games) will benefit less. But what will happen with future GPUs? Because while the 4090 is extremely expensive, prices come down and people often use multiple GPU generations with the same base platform.
Conceivably there are people that will upgrade their GPU to a 5080 or 6070 in the future and potentially end up with similar performance to the 4090. Those same people might have an RTX 4060 or 4070 right now (or RX 6700 XT / 7700 XT), with an i5-13600K/14600K or Ryzen 7 7800X3D.
This is why we try to find games that scale more with CPU rather than less. Because there will always be lots of games where the question of "which CPU or GPU is best" is that it doesn't matter. So we want to know, when your CPU (or GPU)
does matter, how much of a difference can it make?
Realistically, if you're buying a high-end CPU for gaming, you'll probably also have a high-end GPU... and you'll probably also have a 4K 144Hz or 3440x1440 144Hz ultrawide monitor to go with it. And if that's what you're running, most of the time, your choice of CPU will matter very little relative to your GPU (assuming you game at native resolution). I typically suggest allocating about 3X as much money to your GPU as your CPU if you're wanting a good gaming PC. If you're more about doing video editing and other tasks that need lots of CPU multi-threading performance, than maybe 2X as much for the GPU.