100% agree right up until you hit the £300+ mark, unless you don't keep your CPU's very long at all.
There are so many, IMO daft people, who'll buy something like a 10900K/10850K and have in 12-18 months and in this now fast moving CPU market have lost huge percentage of money on it when it comes time to sell, what is worse they'll only be playing games and see almost no benefit in most titles (as of now). A great deal of these people hide behind it has to be the fastest, but will scrimp on RAM, or a decent SSD etc.
The sensible short term use-case is a 6c/12t part, starting at about £120 for the 10400f, now paired with a B560 that can OC the RAM, and some decent 3200-3600 MHz RAM, total spend ~£250 or if you want to push the boat out ~£360 for the 10600KF, Z490 and the same RAM. You cannot beat that for value at all, anywhere. I've almost lost count of the number of 10400f systems I've put together in the past few months, it is almost as good as when the R5 3600 was ~£140.
Once you start looking at the £300+ CPU's, you need to be thinking long term again IMO, but since the CPU market is shifting so fast I'd want the platform that offers the best option to keep it longer, which is AM4, you can chose from a 4c/4t CPU all the way to a 16c/32t CPU and you've got the comfort of knowing if you buy a 5800X then there will be somewhere you can go without changing the whole system, drop in a 5900X, or 5950X, or maybe even a Zen 3+ CPU. If you are buying into LGA 1200 there's no point in 11th Gen (for games as far as we can tell atm), and 10th Gen is EOL as soon as you drop it in, so you are stuck with it or need to change the whole platform.
The person who bought the 10400f/10600k build in 12 months when Zen 4/Alder lake are available, is in the best position to change a whole platform with very little lost in those 12 months, yet they had 90-99% of the performance of the much more expensive system for those 12 months, that likely lost as much in value as they spent in the first place.