Ocarina of Time is still my favourite Zelda game I've played (but those new switch games look pretty great, but very long winded).

Skyward Sword had the best game play but visiting almost every place thrice felt very cheap and boring.