My favorite is Majora’s Mask. I adore the story and I think it has some really solid dungeons, especially stone tower. What I love the most about it is the side quests though. Collecting all the masks and helping everyone in Termina was always really fun to me. It feels so much different from any other Zelda but it still has the core elements that make it Zelda. It gave me my love for games with real time systems and NPCs that exist on a schedule that live out there day regardless of your interaction with them. My other favorites are Twilight Princess and Wind Waker. As far as top down Zelda, A Link to the Past and Minish Cap