Like for example you can play every GameCube game that was ever released for the system. There's readily available archives you can download and well-known console mods available to play them. This kind of thing just isn't possible for newer games.

Self-contained, offline, drm free (or at least breakable drm) will probably be immortal but that's a shrinking segment of games.