Trepid hope. Lets hope I'm not disappointed. Never played the Pathfinder games but everyone raves about them. BG1/2, Icewind Dale, and Planescape torment were the shit. Pillars series was also really good and I still haven't played 2 yet (one day I'll finish 1).
But the amount of fuck you lore in the 40k series that hasn't even been remotely touched upon in any form of media outside the tabletop and books is just criminal. They can do so much with this game in a true story telling RPG classic or CRPG or whatever you want to call it.
Alas with any 40k IP I know to temper expectations.