Even without texture packs, just cranking all settings to the max on a very old game does this.

If you don’t see the enemies, some parts of System Shock 2 look really neat if you render it at the highest resolution possible.