Ah man, Zelda is pretty great in atmosphere, adventure, puzzles and such, a very unique experience especially the Forest Temple in OOT and Under the Well and Shadow Temples too, absolute nightmare fuel lol. Spirit Temple and Deku Tree are really cool too.
It's very exposition heavy but its got a great story too. The first time you arrive at Gerudo Valley in the daytime and that music hits too, OOF, absolute chills too!
Completely true about Mario 64 too, I loved Banjo Kazooie but Mario 64 has aged better and was a far better game imo, Nintendos games were always leagues ahead of others back then imo.
Mario 64 is just so priceless, a once in a lifetime/one of a kind experience. I wish it would get a proper successor or at least a proper remake finally, same with OOT too.