There's 2 things I consider important in a dungeon: Gameplay and story relevance. A good balance of those is essential.
The dungeon that did gameplay best was Arbiter's Grounds. It was great needing Wolf Link for the dungeon, the 2 part nature of it was good, the item fun and the boss fight...