For VTM search for the community patches, it rolls up a lot of stuff as I understand it and a new one was released not long ago.
Clive Barker's Undying is pretty... good I think. It's not a shooter that will blow you away but it isn't really that type of game, it sure as hell isn't Jericho. In parts where the game/levels gets dry/monotonous there's still that curiosity where you want to see more, learn more and that pushes you forward. It's pretty neat and engaging. It also has some unintended scares that works very well.
The thing that will trip you up and take some getting used to is that the character use their right arm to shoot and the left for magic, so right mouse button shoots and left is magic.
edit: just took a look, apparently the gun is in the left hand and magic in the right, but I could've sworn it was the opposite in the version I played.
Either way, I liked it.
Not Barker related but you should really check out Realms of the Haunting by Gremlin. That game was fantastic and went into some weird places.