Depends a lot on 1. workload (algorithm and dataset) and 2. power limit.
Furthermore, bare clock speed is not a reliable performance metric especially when more cores get utilized. Cores can clock very high if most of their cycles are spent waiting for main memory accesses instead of actually computing something.
Absolutely, 100% true. Those TechPowerUp tests only show under default BIOS setting how high the chip will go assuming you have adequate power and cooling.
It's just one data set to be evaluated while keeping what you posted in mind.
This is why, as I have been posting, I'm very interested in how these high core parts on the horizon will clock under MT loads.
For example, drawing 230W my 9950X hits the following all-core clocks
CB R26 - 5270
CB R23 - 5030
OCCT cpu stress steady - 4670
All results are below TechPowerUp's 5336MHZ "light load" best case scenario. Of course you CAN get there if you have adequate cooling and power. Or higher if you want to go PBO.
I am interested in what happens with MT clocks in various loads when you cap Zen 6/Nova Lake at 200W or 230W, etc?