I believe The Beatles: Rock Band came the closest to being perfect. Eveything about that game was just beautifully done and the only things missing was Pro Drums, an option for Keys, and a few more Beatle songs (Hey Jude, Strawberry Fields Forever, Yesterday etc. etc.)
when i was a young kid, i played this game, and everytime i saw a single enemy i restarted the game and just ran around the village. it was long ago, so im not sure if its entirely accurate. ive also never played a zelda game since lol