For sure. I moved from setup with an i7-6700k and a gtx 1070 to one with a 5900x and an rx 6900xt, and in games the upgrade wasn't really as strong as you might expect.
Code compilation, hashing, rendering were all markedly faster though. That old PC became a perfectly serviceable hand me down after 5 years of service, and I hope to get another 5 out of this rig. Pretty cool that we're seeing longevity and some progress at the same time.
Oh, absolutely for what you describe newer chips are going to make a huge difference. The system I'm describing is used by my wife for Steam games, remote desktop, media consumption etc.
My work laptop is an M1 Max and personal laptop an ancient i5 Macbook. I had it upstairs recently and thought I'd do a little coding but gave up after a single `brew install whatever` was still going after 20 minutes and I lost my motivation...
Whenever I use an older laptop I have that is on intel i7, 8th gen, these tasks are much much slower. I think it really depends on your workload.