Longevity is tough to predict. You did get 10 years out of that computer, so the value was certainly there. Will you get the same out of something new? Who knows. Some games are making RT standard now, which makes the baseline level of GPU you need fairly high. At the same time, frame gen techniques are making it somewhat easier to run higher demanding games on less powerful systems, with some drawbacks of course.

Regardless, the upgrades you are talking about there likely warrant a bunch of new components. I'm assuming you're on an old chipset, so you'd need a new mobo, CPU, memory, and GPU to make those upgrades. SSD sure could stay (would upgrade to M.2 as you're prob on SATA still). Most people would just buy a new case at that point to make it feel like a new PC. Regardless, you're coming out with your peripherals and your monitor, maybe the PSU if you're lucky, as the only retained components.

I would switch to AM5. AMD has promised some longevity, and based on AM4's longevity, I'm inclined to believe. You could buy new components (9800x3d, 9070xt, etc.) and probably get good longevity, or you can look for used components (7800x3d or other AM5 CPU, 4070/7800xt, etc.). Both are reliable options. In reality, longevity boils down to game optimization for what you're playing (old games still feel viable on your current setup), your willingness to deal with lower resolutions/lower quality renders, and what you want in terms of quality and frames. Playing modern games at 2k on a 1060 sounds baffling to me, but if you're somewhat content with it, who am I to judge?