For post-2000 games, if you like crpgs you must play the Troika games. Vampire the Masquerade: Bloodlines (NOT 'redemption' - different game by different company) and Arcanum. The former one will be more welcoming if you're used to the current batch of crpgs. Having said that, they're still crpgs in the traditional sense, so don't expect to do any damage with that awesome-looking shotgun if you've only put one skill point into guns and perception, and don't expect that huge mean blade to cut through anything if you've only put one skill point into melee and strength. In fact, don't expect to even HIT anything with a gun unless you've got enough points in guns and perception. Having said that, guns are the most powerful and diverse weapon later in the game (stealth, or the obfuscate ability if you have it, is probably more powerful in 90% of the combat parts of the game, but there are a couple of fights/areas you can't stealth through and you'll need some back-up plan anyway), especially once the automatic weapons become available and DEFINITELY once the flamethrower is available (though you'll only have enough fuel to use it on bosses).
And most importantly - it's a rpg, not a combat-hack-and-slash, so make sure you have good charisma, persuasion and non-combat abilities. You'll need to have combat aspects as well, so don't go charisma/seduction/persuasion/computers/lockpick with a vampire-class that's non-combat-oriented and expect to do well in the later portion of the game. In fact, don't go seduction at all - it's nowhere near as good as the charisma/persuasion combination for a 'manipulate the crap out of everyone' vampire.
Oh, and if/when you see a werewolf in the game...there is at least one way of killing it, and you don't need to have brought any special item with you (it's actually trickier than that, but it doesn't need pre-preparation or meta-gaming), but it's hard. Run. Oh, and it will be faster than you are
If you like older crpgs, the list only gets better - Black Isle/Interplay (former was the crpg division of the latter) was, in my view, the greatest producer of crpgs - Fallout 1-2, Planescape: Torment, co-produced Baldurs' Gate 1-2 with Bioware, Icewind Dale series, and that's without getting to their old 80s titles Wasteland, The Bards' Tale 1-3, etc.
Or the games by Origin. Ultima 1-6 are probably too old if you weren't gaming in the 80s, but they were the dominant crpg series of the era. Ultima 7 is rated by many of the current developers as 'the greatest crpg ever made' (I prefer Planescape:Torment myself, but U7 was the first of the 'create a cohesive world with a real economy, schedules for every single npc, can interact with everything down to baking break' cprgs. Overhead view can be hard to deal with, and of course the 80s graphics. And you need to use Dos-Box to run it on a modern PC, BUT you can download an excellent program Exult that will run both Ultima 7 and the equally good expansion Serpent's Isle, without Dosbox, in better (but still very dated) resolutions, etc.
Just don't expect there to be any handholding, quest chains that railroad you straight towards the finish with no need to think or expore, quests where everything is pointed out to you and you just need to follow the map marker, kill stuff and click through the dialogue, quests that magically show you where to go via some absurd hovering arrow, or for all answers/options to be 'equally correct' ('because there's no wrong answers, kiddies!'). But for many of us, that's the stuff that killed the crpg genre, anyway.