I think people pay too much attention to CPU's (for gaming) nowadays when most should just focus of the GPU. Most modern entry level desktop CPU's are fast enough for gaming without holding GPU's back. As in, if you look at benchmarks (at non silly low resolutions) the majority of titles are GPU limited; especially when you factor in RT and other expensive compute being implemented in more and more in engines. Like even with the 3090Ti there's little difference in gaming performance between the 'low' mid tier of lets say 5600/12400 highest end SKU's.
Of course a 8 core is going to last longer than a 6, but it won't be a factor in this generation or the next of CPU and GPUs. And instead we should be looking at the next generation of consoles, and realistically.. even then we're looking at another 5+ years until a PS6 and Xbox (?), at which our Zen 3/ADL CPU's would have ages a bit and which time a considerable amount of PC gamers/enthusiasts would probably would looking for an upgrade by then.
Btw if we're looking at CPU performance for consoles, the closest CPU's on desktop is probably the 2700X (in single core and multi) and that's been long superseded by modern 6 core CPU's. At least in single core performance.. which is bigger factor for 3D rendering. Looking at aggregate data from reviewers we can see how SC scales with 3D performance throughout the generations; down to the latest architectures like Alderlake, not to mention things like cache sizes etc.
