I occassionally play a bit of Dungeons and Dragons Online, and DDO is just a fine game. I think it does a really good job at translating D&D's 3.5 rules into an MMO. Lots of dungeon crawling, and tweaking your character. Crafting sucks though, but the combat is fun. So that is my golden standard of what a D&D game could be. It manages to nail that feeling of having one player be the Rogue, and search for devious traps, while the other classes follow closely and do their thing. The only thing it really fails at, is storytelling and talky bits, which are bare bones.
The only way you could fit the talky bits in, is perhaps in the way Dragon Age did it. Heck, Dragon Age 1 is basically a modern Baldurs Gate. So that's another good example of what a D&D game could be.