The Water Temple is the best dungeon in the series, and it's also the easiest adult dungeon in Ocarina of Time (first playthrough yes it's confusing but on subsequent playthroughs it has the least risk of death at least for me).
The best puzzles in the series are in Skyward Sword mostly due to...