By influence and impact, it's NES > SNES > Wii > N64 > Gamecube > Wii-U.
But I want to go by overall quality, as well as the software. The impact it has now (not what it had back then).
6 - Wii U
A flop so far, made the same mistakes as the Wii. Has some nice features though. May raise the ranks in time.
5 - NES
Was revolutionary back then, but had tons of shovelware and VERY few of it's titles are memorable now
4 - Wii
Sold a lot, caused a craze, and had a few excellent games. But it lacked in online, third-party, and in hardware, so it became a novelty rather than a revolution.
3 - N64
It did not have many games (due to Nintendo's intent of excluding third parties in fear of shovelware). But the 20-odd worthwhile games it did have were all great, and a few killer apps were among them
2 - Gamecube
An affordable games-focused console with an excellent library. It had the best third-party support Nintendo has ever seen in the past 20 years. However, it lost against PS2 and sold poorly.
1 - SNES
It shaped games from arcade challenges to full-on adventures. Whether viewing it from the lens of back then or today, it still has a lot of excellent games and is Nintendo's most memorable console.