I consider myself a (lapsed?) Nintendo fan as well but, post-SNES, my experience with Nintendo has been so up-and-down and inconsistent:
N64 launched with SM64, which was groundbreaking. I had countless hours of fun playing Goldeneye with my friends. Star Fox 64 I loved and other Nintendo games as well. But a lot of the rest, bleh. There was no Metroid. Ocarina of Time was polished but so dull. No Squaresoft and no JRPGs to speak of, at a time when JRPGs ruled.
The Gamecube I rediscovered more of that Nintendo magic. Metroid Prime, which was one of the finest games of all time, cutting edge visuals plus innovative gameplay and design, and then its sequel. SSBM, which got me into the Smash series. There were other games that I loved for the system that were developed by others but published by Nintendo. F-Zero GX. Eternal Darkness. The mainline Mario and Zelda games, though, man they burned me- Sunshine was not good. Wind Waker was an average game with charming production. Launch itself, with the lazy Luigi's Mansion, was pretty sour, but since SSBM came out that next month I was happy. Lots of droughts but overall the Gamecube was a great console with some third-party standouts. It had great graphical prowess and a variety of games that I found rewarding.
The Wii, not much to say. I bought one. It had a lot of shovelware and the motion controller was a gimmick which got old to me fast. I didn't enjoy the system, my kids didn't like it either, and I sold it for what I paid (bought during the times when they were scarce). Some of this was on me, this was during the rise of the Call of Duty juggernaut, and I was all about shooters then.
I skipped the Wii U.
Switch had me excited, based on the hardware, its portability, and Breath of the Wild. I hunted for months before buying one. Once I got it, I quickly found that BotW was not my cup of tea; the game doesn't measure up to modern open-world games in key ways. Splatoon 2 was fun, Mario Kart was fun, especially in local multiplayer. I skipped Mario Odyssey, as the mascot platformer genre isn't my thing at this point. And... I haven't really bought any Switch games in 9 months. Looking ahead in 2018, I basically have Smash to look forward to and that's it. I don't do Pokemon, never have. Indies are usually cheaper on PC and I don't care for most of them anyway. I feel nearly as down on my Switch as I did on my Wii at the same point in ownership. This year is nearly dead for me, so I'm selling my system and games. 2019 or even 2020 should be better and I'll come back to the Switch when it gets a) Metroid b) price drop.
The Super Nintendo was absolutely fantastic of course but, aside from some points on the Gamecube, Nintendo never really hit those heights again for me. Even looking back at the SNES, they needed major third-party support to pull their magic off. I'd even say that was true of the GCN, with Capcom and Sega support. Nintendo has their inconsistencies with game quality as well. They do better when they have other developers shoring up their weak points.