The N64 era pretty much marked the end of the Nintendo franchises for me.
I grew up on the SMB games (1, 3, and Land, rather) and Super Mario World is one of my top 5 favorite games of all time, but after that, I progressively lost interest. Getting the 120th star in SM64 was kinda bittersweet, as if I knew I was never gonna buy another Mario game again.
Similar deal with Zelda. Ocarina was the end of the line.
Metroid Prime almost dragged me back in. I imported a GameCube just for that game. Then again, after completing it, I sold the console.