Not bad, in fact it's quite refreshing to seeing the early 2000's aesthetics translated into a game. It's funny, I would have probably thought it was total cringe back then but now seeing these scantly clad ladies dance to goth music feels me with a sense of immersion and melancholy, specially after using the money command.
Still, the game is far from perfect. While it has a great deal of roleplaying options combat just doesn't work very well, at least in melee, and specially towards the end (before that I would say it's fine, even good). Level design also sucks when it matters the most: hubs, bars, etc. all look great but the sewers? The hotel where you go kill the Sabbat? The asian vampire temple? Instead of being set pieces like, let's say, a Yakuza game, they simply suck ass.
I also felt like I made a mistake by focusing in melee by the end, made my experience a bit miserable with the combination of those 2 factors I have mentioned.
It's also rather buggy, even after all these years and even after applying most recent Unofficial Patch. At one point I couldn't even get inside my apartment in Downton due to the clutter having being transformed into giant boulders, not kidding. Or the taxi disappearing and leaving the driver floating in the air. The camera also goes insane rather frequently.
The endings I've seen are nothing to write home about sadly.
Overall I think that it deserves to be taken into consideration and recommended but I also think it might be a bit overrated.