Found this comment on Youtube:
"The Ballad of the Goddess is Hylia's theme. Reverse it, and you get Zelda's theme, which plays when Zelda has gone back through the gate of time and remembered what she is.
Take a close look at the gate of time, by the way. It appears to rotate clockwise from the future side, and counterclockwise from the past side (all clocks do that, if you could see through them). So time appears to spin the other way from the other side."
I don't know if it's been brought up, but that's pretty awesome. Doesn't really explain why it turns back into Zelda's Lullaby however in future games though
In regards to the final boss, as great as it was, I honestly thought he would have a third form... What we got was great, but it definitely didn't match the scale of past Zelda final bosses. It was better than the final form of TP's however, the one on one swordfight with Ganon. But the 3 parts before that- coupled with the crazy Zant fight that transported through all different areas- just felt more "final". I thought the Imprisioned would turn into something even bigger and badder, but instead he transformed down into a normal-looking villain. That said, it still felt pretty damn awesome fighting him. I wish I knew I could steal the thunder! D: That would have given me a "holy shit" moment mid-battle, but I instead just defeated him with normal sword combat. IMO, you shouldn't be able to damage him during his second phase unless you figure out the thunder thing.
When he rolled out of the way was great too, definitely added tension.
And the 3rd Ghirahim battle was amazing. I love his theatrics and dialogue, lol. Was it just me or did his ritual dance have a move similar to that one Link does in MM? But anyway, just like that robot pirate that you have to fight off the plank- he was too easy. Getting him to fall down each level look hardly any effort. I never had a problem with stabbing, it worked every time, so I defeated him fairly easily too. But you know what? Harder than most past Zelda bosses. Definitely a cool fight, loved breaking away at his sword. The reveal of his character was unexpected but definitely a perfect fit, and worked great. Thinking about how Ghirahim is to his "master" like Fi is to Link really gives Ghirahim a motive that doesn't feel tacked on at all. Makes me wish Fi had just as much personality
ALTHOUGH, Ghirahim has spent years out in the world, while Fi has been trapped away. And as Fi finally shows some personality at the end, it's clear that these spirits do learn human traits.
The Sky Keep was a cool dungeon imo. I really enjoyed it. But it lacked that sense of urgency and despair. Nothing really epic like past Zelda games, like running up a red-carpet staircase to face the final boss. Instead you warp to the final boss- if you want? I guess the Sky Keep suffered from NOT being the place where the final boss is. It didn't have that presence. I still loved the design however.
And a side thought... I know it doesn't fit the story, but Zelda was such a great character at the start. I would have loved to see more of her character and personality throughout the game. In fact, the whole intro was fantastic. It had legitimately funny moments between Link and Zelda. Thankfully we had Groose, the best Zelda NPC ever, to keep the up laughs throughout the game
I really hope Zelda 3DS takes place in the SS world so we 1. Get more Groose! And 2. get more Link and Zelda interaction as childhood friends. I really REALLY hope we get more from the SS world. It's too good to stop at one game. I hope the 3DS homes games continuing SS like DS cotinued WW (but of better quality >_>)
I'm not writing full impressions until I give it a few days to sink in, but I felt the ending (and whole game) was fantastic overall. Probably the best Zelda game yet (though only time will tell), and Nintendo's best attempt at narrative/cinematics in a game so far. I'd take the Disney/Ghibli style that Nintendo has any day over the more gritty forms of story telling. Can't wait to see what they do with Zelda HD. I hope it's even more story focused, or at least has cool cutscenes like SS, but not as sparse. There were lots at the beginning and end, but not many throughout the course of the game. Obviously I don't want a Zelda game filled with cutscenes, but a few here and there to give the world a little more character doesn't hurt.
EDIT: And seeing Zelda's journey in the credits was an awesome touch. Wasn't expecting that!