As far as I know, clock speed is still pretty nice to have, but chip development has shifted towards adding multiple cores because it basically became technologically impossible to continue increasing clock speeds.
A nice fun fact: if you consider how fast electricity travels in silicium, it turns out that for a clock that pulses in the tens of billions of times per second (which is what gigahertz are), it is physically impossible for each pulse to get all the way across a 2cm die before the next pulse starts. This is exacerbated by the fact that a processor has many meandering paths throughout and is not a straight line.
So at any given moment, there are several clock cycles traveling throughout a modern processor at the same time, and the designers have to just "come up" with a solution that makes that work, nevermind the fact that almost all the digital logic design tools are not built to account for this, so instead they end up having to use analog (as in audio chips, not as in pen-and-paper design) design tools.
as a typical rule of thumb, since games will always be limited to the number of threads they use, and rendering/compiling/etc typically uses everything it can get.
And CPUs with higher core counts tend to have lower clock speeds per core, leading to games sometimes running much better on mid-range hardware than on the latest and greatest.
nowadays dwarf fortress has built in multithreading (and the combination of other optimizations and the progress in CPU power has made it a fairly well-performing game overall)
So if this should be like F1 racing, where's the exciting part that's actually a race?
It seems more like a mail in chess game, where a new number gets posted occasionally.
As it happens, overclocking is one of the few reasons to bother with the 14900ks.
"Hey, guys, you know how our top desktop cpu runs hot, is really expensive, and loses in most gaming benchmarks to an AMD cpu that costs $200 less? Let's fix that by releasing one that's 2% faster, gets even hotter, and is even more expensive." - a daily conversation at Intel.
Holy shit what is the average freq for this cpu? They probably had to increment the Volatge by a LOT. I mean what technology is this 10nm? The capacitance of those devices takea big part on latency