For me, the rough tiers for the series would be:
Always happy to play:
- Ocarina, Majora, Link Between Worlds
Good, but maybe take a break in between replays:
- LttP, Link's Awakening, Minish Cap, Wind Waker, Twilight Princess, Phantom Hourglass, Spirit Tracks, Skyward Sword, Echoes, Age of Calamity, Cadence of Hyrule
Okay, but not planning to replay any time soon:
- Breath, Tears, Hyrule Warriors
Never again:
- Zelda 1, Zelda 2, Oracles of Ages/Seasons
Not played/no opinion:
- Four Sword (Adventures), Triforce Heroes, CDi games
For me, the two Wilds-era games are fantastic technical achievements, but are just too big for what they offer - I've started BotW half a dozen times, but only finished it once (technically twice because I reloaded my final save in order to show off the ending to someone); Tears, I've only played once through, having learned from my experiences with Breath.