It sounds like you want a computer game translated as directly as possible to the pen and paper game table without the "ickiness" of actually having to act anything out. D&D can be played like this but from my experience generally isn't because as it says on the lid, it is a roleplaying game. [A computer "RPG" is usually not an rpg at all].
I think the best example of what I'm looking for is an old board game called Hero Quest. I played it quite a bit as a kid and absolutely loved it, but it is far too simplistic to get much entertainment out of it as an adult. The game was essentially a dungeon crawler where each player controlled a character (Wizard, Barbarian, Dwarf, Elf) and went through the dungeon killing monsters and accomplishing a quest (killing a demon, rescuing a princess, etc.). The DM would either use a pre-existing campaign or create one of his/her own. A D&D lite without the role-playing aspects.
What I want is the D&D combat, the group socializing, the roleplaying aspect of Dragon Warrior "The evil (he doesn't do anything evil, but take my word on it) Dragonlord sits in his castle. Go beat him up, nameless hero.", with the dungeon crawling of Hero Quest (or Diablo I suppose).
Anyway, I doubt I'll drop out before even starting. I was just getting a little frustrated with developing my backstory and creating my character sheet. However, my friends are rather into the story/role-playing aspect, so I am rather doubtful. I suppose the big question is that if I don't enjoy playing with this group, might I enjoy playing with a more combat-oriented group?