I thought it was pretty epic and unexpected. And they did kinda try to do it again in Four Swords Adventures if that part counts.
I remember in my first play through of that game and getting to that level, and I ran out of time in the part when Zelda opens the last gate and theres the bright...