Red Faction deserves a very honourable mention here. It revolutionised gameplay with the Geo-Mod engine, which allowed you to blow up anything. No key card? No problem. Blast your way through the wall.
That is why Red Faction deserves to be hailed as one of the best games. It is, quite simply, a revolutionary game. Red faction 2 also used the geo-mod engine, but not to the same extent as the original. In RF1 you could take down a bridge with a grenade or rocket laucher, and that is a beautiful thing to see. All those games claiming to have fully destrictible environments owe their thanks to Red Faction, the true innovator of destructive gameplay.
And the story is good too, as well as the gunplay. One of the best things though, would be how realistically characters react. If you attach a remote charge to someone (especially a civilian ) then they won’t just stand there. They would run around screaming and flailing their arms until you press the detonator. It’s little extra touches like this that make Red Faction such a joy to play.
EDIT: Underscore, I have the 2 in one cartridge for the NES with Super Mario Bros and Duck Hunt in… Don’t know anything about that Powerpad Track game.