I wrote an informal review of the game in a journal of mine, but I thought I'd post here highlighting some of the positives and negatives. Please note there are some minor spoilers below.
Favorite character: Midna.
I think this is obvious to whoever plays the game; she has the most backstory of any character and actually speaks unlike Link who simply sighs and grunts. (Well, Zant is another choice, I suppose). But then again, Zelda games aren't necessarily about story and characters. Those are previously established.
Favorite dungeons: Temple of Time, Palace of Twilight.
These dungeons come later in the game, but they are a lot of fun. I view them are parallel opposites. The Temple of Time is in the light world while the Palace of Twilight is obviously in the shadow.
Biggest "pain-in-the-ass" dungeons: Lakebed Temple, City in the Sky.
I got stuck on Lakebed Temple after I assumed I had permanently ****ed it up, but my friend, Maht, proved me wrong. So, without his help, I probably wouldn't have found the motivation to finish the game. City in the Sky is the longest dungeon and the easiest one to get lost in. Compared to some of the other dungeons, it's just too tedious. I believe it took me about 3:30 hours to get through it.
Most fun part: Assaulting the Hidden Village "Western style."
A highlight of Twilight Princess was stealthily picking off Bulblins with the Hero's Bow to the tune of Western music.
Most irritating parts: Trying to reach treasure chest #81 with the spinner (which I never did, because I could never gain enough speed); tracking down each of the poe souls and having to wait around until night again to catch them; fighting three Darknuts at the same time in the last room of the Cave of Ordeals.
These things are self-explanatory.
There were definitely some nice moments in the game, but story just falls short. It's much too basic. Regardless, the gameplay was incredible. Terrific puzzles, mini-games, and well-designed enemies made this game worth playing. If you're looking for great characters and story, you might want to look elsewhere.
I'm not sure if I had more fun with the Wind Waker or Twilight Princess; I think there was better design in Twilight Princess, but I remember having more fun with the Wind Waker. It's definitely a more lively game.