Dark Heresy is an RPG in the 40k universe. Same setting as the miniature wargame, but more similar in play to D&D.
From what I read of 'em, the combats pretty brutal,(It is 40k after all) and players don't get super powerful. Being human in a universe full of daemons, orks, and space marines...