Most games from any era are terrible by any standard.
The games that are considered the absolute best from the olden days, like SMB1/3, F6/7, Chrono Trigger, Donkey Kong Country, Super Metroid, Ocarina of Time, Castlevania Symphony of the Night, ect. absolutely hold up today.
I actually find that I still prefer N64 shooters like Goldeneye and Perfect Dark to the Xbox/PS2 generation of shooters like Halo