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.)
I have to agree with you there. The music, the scenery, the plot, just the general aesthetic of the game was incredible. It created an experience in play. I can’t tell you how many times I restarted characters and classes to play through in a slightly different experience. I still pick it up and play occasionally, even though I’m the only one from my guild who has logged in for the past 3 years, it’s nice to just see and experience the game again.