I enjoyed the Blood of the Night book, I feel that it was well written and had some nice things for Dhampires (and even for vampire PCs if anyone ever allows them). The hunger rules while suited for vampire PCs, could be used to make some interesting stronger/weaker ghouls without a template or a huge amount of work. I feel that this book would have been right at home in a Van Richten's guide era Ravenloft source book.
That being said, the vampire rules, while nice, are not something I'd use in my games for PCs. I like the expanded Dhampire section as well as the new magic items and vampire hunter feats.
If you're a DM/or a player in a vampire hunting focused game, this book would be great to have, but for a standard game, unless you know your DM is going to drop some vampires on you, or you want to have a great angst back story for your Dhampire character, there's not a ton of reasons to pick it up. However, since I am getting it as part of my subscription, I'm not disappointed with it at all.
Final thoughts, if you're trying to talk a DM into letting you keep running your character after you get turned into a vampire, get this for him. Or if you have an interesting idea for a campaign built around a few vampire PCs, grab it, you won't go wrong.