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.)
daggerfall is so messed up that the legitimate strategy to beat the game is go in and out of dungeons and waiting for the quest item to randomly appear next to the front door