1. The N64
I grew up with NES and Super NES. When the N64 was announced, I was super-hyped! I had a promo VHS where they showed bits of Mario 64, Wave Racer and some other launch titles. I watched that tape easily a hundred times and begged my mom to preorder one for me, which she eventually did.
I ended up owning three games for the N64: Mario 64, Zelda OoT and Mario Kart, none of which I remember too fondly. Especially Zelda OoT - SNES Zelda is probably one of my favourite games of all time and I found the transition to 3D godawful. Never made it past the 4th temple or so. Similar with a lot of other franchises I loved - they either were inferior to their (S)NES precursors (Starfox, Mario, MarioKart), or there wasn't an N64 entry at all (Metroid, Street Fighter, Mega Man), which was actually for the better, I guess. Also on the SNES I first came in touch with cRPGs like Eye of the Beholder and Might&Magic 2 (Albeit those ports already suffered from console decline, as I now know). What did the N64 offer? Quest 64.
Fuck this console, seriously! Why is it so loved? There are maybe 5 games I could recognize as classics, two of them aged horribly (Tried to play goldeneye the other day. Lol those controls and render distance :D )
Boom. My choice was gonna be Ocarina of Time, but you've summed up the N64 on the whole for me too. It was a complete downgrade in almost every way from the previous eras, and a sack of shite.
As for Ocarina of Time, like yourself I loved Link To The Past to bits, definitely in my Top 10 games of all time, and so I worked 2 weeks of 12 hour shifts straight so that I was loaded with cash and could have X-Mas day through New Years off indulging in Ocarina of Time (alongside the likes of Mario 64). It was fucking wank, janky as fuck, puzzles which were a complete breeze (people go on about the Water Temple, but I can't remember it giving me any jip), and boring shit like dicking about on a horse in a field dragged it down further. and Mario 64 felt like a huge step backwards from Super Mario World too.
I've a burning hatred for the N64 and most games on there. I also especially detest how Goldeneye is held up as the bees knees of FPS gaming of that era, when LANing Quake 2 and Hexen 2 at the college offices was way, way better.
Honourable mention to The Witcher 3. Having really enjoyed the earlier games, they fluffed the lines on 3 big time.