I think I've found a good example to correct this long running myth once and for all.
I get your point, however that's not true as I've said before.
Modern Warfare 2 (MW2) using the default out of the box configuration, requests use of all 16 cores of the 7950X3D as it uses a default CPU render worker thread count of 16 for 16 core CPUs.
Now, based on your assumption, the workload would be stuck on the first CCD (cache) and the second CCD (frequency) will be asleep.
Here's a video of MW2 using the default out of the box configuration for 16 core CPUs. Note the workload spread over all 16 cores.
Now, I've edited the MW2 config to make it use 6 render threads instead of 16.
Here's a video of MW2 requesting 6 CPU worker threads. Note the workloads are now pinned to CCD0 because the game is not requesting to use more than 8 cores.
The workload is not stuck on one CCD, it is spread out and both are active during the workload if the game wants to use more than 8 cores. So to say that 7950X3D when gaming is stuck to one CCD only is false. However, most games do not request more than 8 cores for workloads. Most games work best with 8 or less CPU worker threads. The games that actually benefit from more are few and far between. Even the example I've now used, MW2, performs better if you override the default settings and change the worker count to 6 or 7. Of course most games won't let you change this behaviour, it's hard coded but the point remains.
I could be wrong about Doom then. I may have been thinking of a different game.