Second place for me would be the Wii.

Mario Galaxy 1 & 2, Xenoblade Chronicles, Metroid Prime 3, Monster Hunter Tri, Zelda Twilight Princess and Skyward Sword, Donkey Kong Country Returns, Fatal Frame 4 and the reimagining of 2, Sin & Punishment Star Successor, the Goldeneye 007 reimagining, Mario Kart Wii, The Last Story, just so many excellent games, many of them criminally overlooked.

I think we should only count games that were released for that hardware and not BC and ports right? Because otherwise I think Switch would blow up everything else

1) SNES: Pinnacle of 2D gaming, so many quality titles: A Link to The Past, Super Mario World, Donkey Kong Country trilogy, Star Fox, Final Fantasy VI, Super Metroid, Chrono Trigger, Megaman X, my favorite: Yoshi's Island!

2) Switch: WIP, but damn good library. Mario Oddysey, Splaton 2, FE Three Houses, Astral Chain, Breath of The Wild, Animal Crossing New Horizons, and that's just the exclusives there are very good 3rd parties too like DQ XI, Immortal Fenyx Rising, Octopath Travaler, etc

3) 3DS: Solid library too even if somewhat smaller, A Link Between Worlds, Yokai Watch 1 and 2, Pokemon Sun and Moon, Fire Emblem Awakening, Super Mario 3D Land, Kid Ikarus Uprising, 

4) DS: Pokemon gen 4 and 5, plus remakes plus Mystery Dungeon (I really like most of Pokemon input from this era), Dragon Quest IX, Phantom Hourglass, The World Ends With You, Yu-Gi-Oh Nightmare Troubadour. I'm ruling out some SNES games I've only played from DS otherwise it would be higher

5) N64: Have some great games there are here, even if they haven't aged that well. Mario 64, two wonderful Zelda games, Star Fox 64, Pokemon Stadium 1/2, Yoshi's Story, Banjo Kazooie, Kirby 64, Pokemon Snap

6) Game Cube: Played mostly thanks to emulation, but here it goes: Wind Waker, Resident Evil 4 (I only know the PS2 version though), Metroid Prime, Resident Evil (game cube version)

7) Wii U: Has a surprisingly tiny but good exclusive library, BOTW, Pikmin 3, Tropical Freeze, Captain Toad...

8) NES: I don't really think their games aged sufficiently well to be played. I find original Final Fantasy ok-ish. I really do like Super Mario 3 though 

9) Wii: Mario Galaxy, DK Country Returns and... err... Xenoblade I guess?

I don't know enough about GB/GBC, GBA or Wii U. I'm still ranking Wii U nevertheless because I've played some of its games on Switch. For GBA there is 3rd gen Pokemon and The Minish Cap

Strong disagree on NES games not aging well.  Super Mario Bros, The Legend of Zelda, Mike Tyson's Punch-Out!!, Contra, Mega Man, Castlevania, Ninja Gaiden, Double Dragon II, and many others are just as enjoyable to play today for many people as they were in the 80's and early 90's.  Millions of NES Classics were sold because of this.  And, Nintendo has been able to resell those titles multiple times through Gameboy Advance, Wii, DS, 3DS, WiiU for the same reason.  Many of them also have thriving hack/modding communities today, because of how many people enjoy playing some of those titles so much that they want to continue playing them but as new experiences.  I myself was amazed recently to find that Tecmo Super Bowl has a community that has contributed so many roster updates that you can play almost any season in NFL history from 1958 to today.  You can even play seasons as the CFL, or the defunct USFL and World Leagues.

Should I add "for me" then?

NES games already looked ugly and clunky for me even when I was a kid playing PS1 and N64

I'm not discounting your right to have a personal opinion.  I'm just countering that there are millions of people who don't have any problem with the graphics and gameplay of many NES titles.  It's the reason the NES Classic sold so well to the point of being almost impossible to find, while the PlayStation Classic was being discounted into the bargain bin a month after release.

Millions is a overstatement, there are some hundred thousand people who enjoy NES til this day still. It's a classic and part of the childhood of people who started playing games in the 70's and 80's. While kids from the 90's don't have nearly as much love for 64, Saturn and PS1 era. 

I actually think this is much more a difference in culture and how games are consumed for different age audiences. I'm a kid of the 90's and I have no interest whatsoever for either PS classic or NES classic

If you ask me whether I like more PS1 or NES, then I would easily say PS1. I would like to play some of their games if they were available on some cheap subscription service, but would never buy a Console specifically made to play them 

I don't think it is though.  The NES Classic sold 3.6 million units as of june 30th 2018.  It was regularly out of stock at retail while it was in production, and heavily scalped on the secondary market.  Nintendo could have easily sold quite a bit more if they were interested in maintaining production, but by September 2018, Nintendo was pushing the NES games as a perk of Nintendo Switch Online paid subscription.