Awesome Moments - In the original edition, The Ordo Dracul's Coils of the Dragon were passive disciplines that modified the dragons existing state, making easier to be a vampire. this was considered to be a step in the right direction towards the Ordo's goal of transcendence. In Blood and Smoke: The Strix Chronicle, The Coils will be Proof that the Ordo can, will, and do succeed in transcending the Vampiric Condition.
Fridge Horror - All over the place, which is saying a lot when the game is already about horror.
A relatively mild example: independent Moroi (see Crippling Overspecialization). Most are kept on a short leash by the Ordo Dracul; most of the rest were killed. However, this means logically that there are those of the bloodline that didn't want to be leashed killers, enough that they refused...and survived. Meaning there are creatures out there powerful, cunning, or just plain tough enough to avoid targeted destruction at the hands of an entire covenant. This is actually discussed—bringing in or bringing down such creatures is sometimes tasked to disposable coteries that are more trouble than they're worth—but the implications aren't really delved into in-text.
The Ghouls. It's hidden right on the surface, but when you make a Ghoul, you ruin a persons life as thoroughly as any addiction. The horror is explored in the Ghoul splatbook, with a Ghoul so desperate that he drinks the menstrual blood of another, recently fed ghoul. But otherwise the horror you wreak on this person is just implied.
Even more so: It's implied the reason the Duoloi, the ghouls who serve Belial's Brood, are so loyal is because of how well they're treated compared to mainstream ones. Yes, you read that right-the Card Carrying Villains treat their ghouls better then every other vampire in existence.
And by "how well they're treated", it's implied that any ghouls recruited by the Brood are already just as evil as the Brood vampires...so the Brood vampires are happily helping evil ghouls indulge their vices.
"Funny Aneurysm" Moment: One of the books, trying to encourage STs to emphasize the Darker and Edgier elements of WoD, pointed out how low New Orleans is below sea level, and how unstable the WoD-versions of the levies would be, what with it being a Crapsack World and all. Cue Hurricane Katrina...
Which is explored in Pandora's Book, which suggests a few ways for crossover-interested Storytellers to work with post-Katrina New Orleans.
The clanbooks also have a running narrative involving a wave of nightmares being spawned by the destruction of several vampires during the storm, as well as a number of very bad things happening to the survivors.
To drive the point home, the original supplement's suggested outcomes for such a story were much more positive than how things actually came out.
Idiot Plot: The following is either an incredibly good (bad) example of an idiot plot, or the horrors created by the greatest Kindred Chess Master of all: the Ordo Dracul book gives the story of the Azerkatil bloodline's founding as a convoluted plot a mysterious vampire called the Red Sultan engineered. He thought his rival in life, Dracula, had used his strange Coils of the Dragon to become an actual dragon. He also thought it was necessary to create a task force to slay this dragon. The Red Sultan commanded the creation and destruction of multitudes of bloodlines. The rules say it takes a powerful vampire, and a few generations of childer, to create a bloodline, and it seems the Red Sultan was able to sacrifice many of them... He's also still extant. So, either those powerful vampires were all idiots, or the Red Sultan's a Chess Master.
Jerkass Woobie / The Woobie: Any vaguely sympathetic vampire probably qualifies. Kindred as a whole are manipulative, backstabbing bastards who survive by treating humans like cattle, playing on people's superstitions and frequently abuse them. But on the other hand, they are genuinely fighting with the Beast and desperately clinging to their humanity, and usually end up losing the battle. Especially blatant in 2E, where Humanity no longer just defines their moral code- it defines how much they still relate to Humanity despite being undead.
Nightmare Fuel: Goes without saying, though the Nosferatu discipline of Nightmare is, as might be inferred, an excellent example.
Notably, there's Cymothoa Sanguinaria, a hideous parasite from Wicked Dead. Once it infects a mortal host, it begins usurping control of the body, driving the host to seek out blood. As time passes, the parasite takes full control, leaving the host's consciousness aware but powerless, forced to watch everything the parasite does. And that's not getting into how exactly it spawns... Based off a real-life parasitic isopod, Cymothoa excigua, that commonly replaces fish's tongues.
And then there's the Strix. When facing off against purposelessdemons is the least of your problems with them, shit gets real.
Rule-Abiding Rebel — Some Carthians try to find reforms for the Requiem that don't disrupt the Invictus-derived model of praxis, lest they get boots on their necks.
They Changed It, Now It Sucks: The Brujah becoming the Bruja could very well be this for any player of Vampire: The Masquerade transitioning over to the new setting; aside from being downgraded from a full-fledged clan to a bloodline, the original Brujah were revolutionaries who shaped history with uprisings, activism and passion, rebels, punk rockers, working tirelessly to improve society. Vampire The Requiem's Bruja? Are a psychopathic criminal biker gang who proudly uphold greed and sloth as values and makes money by taking part in things like prostitution, drugs-trafficking and illegal arm trading. All of them. It was clearly done to streamline the clans along with many other, more well-received changes, and the Gangrel in the new setting can serve more or less the same purpose, but it does come as a bit of a slap in the face to some older players in order to make a hamfisted attempt to add vampires similar to those from From Dusk Till Dawn.
Uncanny Valley: The lower the humanity, the closer a Kindred is to this.
The Haunts can be fugly bat-faced monsters out of your worst nightmares or they can be beautiful... perfectly beautiful... disturbingly beautiful.
Some of their bloodlines lack any flaws in their appearance, but are so taken by their Blue and Orange Morality that it's the same issue.