There's a reason why Ganon is Power, Link is Courage, and Zelda is Wisdom, after all.

That would actually be an awesome final dungeon to the type of game I described. She escapes the prison through stealth and comes in to aid Link in the final battle against Ganon in an intricate, puzzle-like final boss fight where your goal is to incapacitate him from the shadows while Link does the real combat.

She already has her own game though! Zelda's Adventure on the CDi :D

Did you play Skyward Sword?(without going into spoilers) she did a lot to help Link for a large portion of the game and she never really played the traditional role of damsel in distress. Llike I said, I don't want to go into spoiler territory, but I think its clear that her role was quite distinct from what people typically think of when they think of rescuing the princess.

While I obviously do like my suggestion, it was only an example to show that Zelda can be in a game that makes sense for her character without weilding a sword, shield, and tunic.

Reminding people of these CDi games should be a bannable offense. xD

Although not lead role :P

While you make a great well thought out argument about why Zelda shouldn't be a warrior, the great thing about Zelda games is that they can always start out with just the basics of the background story and so these characters can be in just about any situation like when Sheik or Tetra were introduced.

That kind of freedom is also why we got Link on a train however:/

I knew someone would bring up Kafei.

Exactly why I said "lead role"

This, I'll add rescuing someone doesn't negate their impact, a large number of the 3D games she actually has a key role in helping out, she funny enough is one of the more active characters of her type in gaming.