It's too bad you're missing the Super Nintendo (SNES)
SNES_
The Donkey Kong Countries
The Mario Worlds
Mario Allstars
The Super Metroids
Super Mario RPG: Legend of the Seven Stars
Chrono Trigger (without the awful of the PS1 re-release)
FF6
Mega Man X 1, 2, and 3
Kirby Superstar: 8 Games in 1
Zelda: A Link to the Past
Anywhoo, I'll list common good games for those systems too.
PS1_
Final Fantasy 6 (via Final Fantasy Anthologies)
Final Fantasy 7
Final Fantasy 9
Final Fantasy Tactics
Mega Man X Collection (which is Mega Man X 1 through Mega Man X 6)
Mega Man 2 and 6 (via Mega Man Collection)
Arc the Lad 1 and 2 (via Arc the Lad Collection)
Threads of Fate
TimeSplitters
Ehrgeiz
Brigandine!
Tactics Ogre: Let Us Cling Together
Twisted Metal 2 (TM1 is only one-player, TM3/4 are by 989 Studios instead of SingleTrac... so you can imagine how
in' crappy 3/4 are
)
Saiyuki: Journey to the West
Rogue Trip
Chrono Cross
Legend of Dragoon
Xenogears
PS2_
Final Fantasy 10
Final Fantasy 12
TimeSplitters 2 or TimeSplitters: Future Perfect (aka TimeSplitters 3)
Soul Calibur 2 (watch out for game-saving glitch on Soul Calibur 3!... 2 is glitch-free though, no worries)
Twisted Metal: Black
Kingdom Hearts
Dynasty Warriors 3 (Dynasty Warriors 2 isn't so good, haven't played 4, 5, or Tactics yet)
Eve of Extinction (EOE)
Star Wars Battlefront 2!
Dark Cloud (haven't played DC2)
N64_
Ogre Battle: Person of Lordly Caliber
Super Smash Brothers
Star Fox 64
Super Mario 64
Jet Force Gemini
Golden Eye
Mario Kart 64
Diddy Kong Racing
Zelda: Ocarina of Time
GBC_
The Wario Worlds
Zelda: Link's Awakening
GBA_
Fire Emblem 7 ("Fire Emblem")
Tactics Ogre: A Knight of Lodis
Fire Emblem 8 ("Fire Emblem: The Sacred Stones")
GC_
Fire Emblem 9 ("Fire Emblem: Path of Radiance")
Tales of Symphonia
Super Smash Brothers Melee
(some games I already listed under PS2 such as TimeSplitters 2, TimeSplitters: Future Perfect (aka TimeSplitters 3), Soul Calibur 2, and Star Wars Battlefront 2)
I don't know anything about the DS or PSP's games others than the Twisted Metal for PSP.