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.)
Dragon Age. I literally fell in love with Alistair while studying for my masters, so it must have been an excellent storyline for an RPG. I also played it through in full twice because it turned out my initial character choice made my perfect ending impossible…