Idk if its true for everyone, but playing and reflecting on a lot of Zelda recently, I feel like the best dungeons are often ones people have historically complained about for being too difficult or obtuse.

Water Temple
Wind Temple (WW)
Lanayru Mining Facility (SS)

Food for thought ig