Yeah, while my mind did go to GoldenEye, this really applied to NES, SNES, N64, GameCube, and ps2, out of the systems I have/had.
My wii u games are still playable, though they might try to connect to a server that no longer exists to look for updates. Similar with ps3 (though I think my system needs an overhaul because it's running pretty slow these days, like many dropped frames in rock band 2 or even some in GH3).
For the ps5, I'm not sure what will happen when Sony no longer wants to support it. I mostly have physical games, maybe I should try disconnecting the internet and see what happens if I try to fire up random games, both ones I've already played and ones that haven't left their case yet.
Anyways, I mostly thought of the era of the first paragraph, since the others have updates.