From a 2-player simultaneous perspective (which is best when people are visiting), the non-MAME games that get the most play from my kids and visiting friends are..
Atari 2600 : Frogs n Flies, Combat, Fishing Derby, Freeway, Bowling
Genesis : Toe Jam n Earl, Zombies Ate my Neighbors, Streets of Rage 2, Sonic 2, Golden Axe 2, Gain Ground, NBA Action '95
(not a console, but worth mentioning) Atari 800 : Dog Daze Deluxe, Claim Jumper, The Realm of Impossibility, Spy Vs. Spy, Seawolf 2, Archon, One on One
NES : Super Mario 3, Pro Wrestling
PSX 1 : Tekken 3, Star Gladiator, Twisted Metal 2