On my side, I still think that by 2029-2030 anything over 32 cores would still be pretty high-end.
I still remember the long, long time through which 4 cores / 8 threads were the thing.
If you mean for gaming, no not really. Those high core count CPUs are about maximum throughput, not per core performance.
That is the main thing with Intel's planning. They are vastly increasing the E core count for multithread. AMD, due to their extreme modularity, is kind of stuck with adding more full sized cores. They do have compact cores, but those aren't really making it into desktop so far. Either mobile or server for now. They could make a hybrid chip for desktop, but I don't see that happening outside of the APU class.
32 cores purchased today is likely going to be 'mid-range' 5 years from now. We saw that with Threadripper. Those 16-32 core CPUs look good on paper, but you throw a 16 core Zen 5 part at them and they tend to lose. It will be the same. The node shrinks are architecture improvements, maybe even feature improvements, will more than make up for less cores.
I think we will see 16 core high end chips become normal for the general enthusiast as 8 core is today. And I think 8 core will become the new budget category (like 6 cores has become today). Particularly with Zen 6, if they are doing 12 core CCD, which will make the top chip consumer chip 24c. Intel is already leaning towards 16P cores and 32 e cores, plus LP power cores.
I think we are going to see the end of the quad core outside of low power solutions within the next generation hardware.