Majora's Mask being a top contender. Down to the idea that the main dungeons in my opinion, give the feeling that they are secondary compared to the side quests where it dives into the stories and lives of the NPCs in such a game. And I find it facinating and immersive.
However Breath of the Wild is a go to for me due to more accessibility and well, Open world. Duh.