Clock speed isn’t relevant, IPC is, and the 5800X3D has by far the highest IPC of any cpu right now.
Wrong. In a big way. IPC stands for Instructions Per Clock cycle. With 2 cpus at the same Hz, the cpu with higher IPC will do more work over the same time period. That's balanced by cpus at different Hz. A 12900k at 5.0GHz will do more work than a 5800x3D at 4.0GHz, even though the Ryzen might have higher IPC, it's not enough to compensate.
For example, if the Ryzen could do 100 instructions per Hz, that'd be 400G instructions. If the Intel could only do 90 instructions, that'd still be 450G.
Clock speeds matter. Very much so.
Btw nearly nobody tinkers with their CPUs in general and especially since it’s not worth it anymore since 10th gen with Intel and Ryzen boosts very high
Wrong again. There's a very large section of ppl, especially gamers who 'tinker' a lot with cpus, but instead of overclocking, they are undervolting, which is essentially the same thing except for the use of the multiplier. Can't even say Ryzen owners 'tinker' more, in fact it's Intel owners who tinker the most, trying to pull down Intels huge power draw, just to keep temps in check.
The 5800x3D is a good cpu, but it's only very good in certain situations, it's basically no better than a 5800x in many situations, and plenty worse in what's left. With that, coupled with its price, it's overall not the greatest value cpu, nor even close, and longetivity planning is a bad idea. You'd end up ahead of the game with a 12400/12600 today and a 14400/14600 in a few years, for less than the cost of the 5800x3D now.
Big and powerful cpus are only of any value if used now, future proofing is a fools gamble relying on software catching up to what cpus can do, which doesn't happen often.