For much of the 2010s, we were stuck with mainly dual-core and quad-core CPUs in PCs. However the arrival of Ryzen shook the PC industry, causing a rapid increase in core counts. At the time, there was fervent discussion on this matter, with many questioning if more cores were worth it, and how many cores are more than enough?
So how do things stand today? The latest Intel and AMD consumer processors top out at 24 and 16 cores respectively. What extent of modern software can take advantage of all those cores? What modern workloads are still bottlenecked by single threaded performance?
Depends.
Microsoft uses saphire rapids (cpu that got smoked in reviews) couse it has better single core performance for their AI servers. You will find a case for CPU.
For PC depends on your workload. If you are doing normal stuff + gaming just buy this or last gen i5/r5. No need to waste money.
You will have more single and multi thread performance than you need.