I believe this will mostly affects games which were lacking in technology.
I’d personally LOVE to see The Sims 1 or The Sims 2 re-released with performance and resolution upgrades, and, most importantly, made to be open world. Since they’re older, I believe they could very easily render the entire map like The Sims 3, but with the charm of TS1 or TS2.
I cannot think of other games, since most games I see as adequate, whereas TS1 and TS2 were bound by system performance during their respective times.
You can actually get a lot of old PC games up and running with a touch of work these days. DOSBox can get many old, DOS based games running. And this extends to some of the games which came out during the Win95/Win98 era. There is also PCem which will outright emulate an old PC from the hardware up. Useful for dealing with software which was tied to the CPU clock.
For consoles, there are plenty of emulators out there which will run those older games pretty well. I’ll leave it as a exercise to the jolly reader to figure out where/how to do all that. Suffice to say, this usually requires just a bit of work.
All that said, it would be nice to have official versions. I’ve personally bought my all time favorite series (Quest for Glory) through Steam. All they did was pre-package it with DOSBox; but, it saves me the trouble of digging out my original CDs and configuring DOSBox myself.