Honestly, I'm a bit miffed with DA:2. It's a good game, nothing wholly wrong with it, it just sort of under-delivers. The same locale the entire game doesn't help (honestly, wtf?), and contrary to popular reviews, they do in fact reuse the same dungeon levels. (A f-ing lot, actually, so I don't know where some people get off saying all the dungeons/levels are varied. It has to be one of the biggest offenders for "reused material" in any recent game.)
I wish there was a next-gen Vampire: Masquerade, since OP reminds me of it. I've been keeping an eye on "The Secret World", (Funcom MMO). The setting and lore looks out of this world unique and interesting. There is virtually nothing similar that can be played at the moment, even for single-player games. The ones we do have, are Very outdated or very short, like Amnesia: Dark Descent.