I want a Legend of Zelda campaign pretty badly.
But there have been a few "collect the X pieces of Y" campaigns (the old Rod of Seven Parts proto-AP and Shattered Star off the top of my head). So why am I not satisfied?
Because the quest to reunite the Triforce isn't what makes Legend of Zelda games. It's reuniting them by traveling through all manner of incredible locations and beating a series of puzzles, monsters, and devilish bosses that are more puzzle than monster.
Even in 4e, which really should be good at that, never had the boss or adventure support to make it a reality. I'd like nothing more than to see a campaign deliver on the promise of a video game boss backed with the flexibility and power of GM adjudication.
Cheers!
Kinak