Not counting PC (seems not to be in the spirit?), my ranking of those I played more than once or twice:
1) Xbox One X - it's recent but with work, kids, etc.., the gamepass has been incredible. It's just amazing value, and I've tried a ton of games I'd never otherwise consider. Just re-upped for two years.
2) Wii - I don't have a lot of gamer friends, and this was the console for them. Played Wii Sports golf a ton with my dad. Super Smash Brother tournaments. Endless nights of Rock Band with friends. And of course, exclusives like Mario and Zelda. Just talking about it, I might have to hook it up to my current system to load up Rock Band again.
3) Gamecube - housemate owned one in college. Great controller. Pretty fun but the weakest Nintendo entry in my mind.
4) Dreamcast - Soul Calibur was fun, that's about all I remember! (Roommate had the console.)
If N64 was included, it would top the list. GoldenEye, MarioKart, Ocarina of Time... wow. And I never really had a chance to play any of the playstation consoles extensively, so couldn't include.