I’ve seen the Vampire and Werewolf final books. I believe the Mage one is due out April 1, and then there’s another one coming out to finish their minor lines (Changeling, Hunter, Mummy).
Each book has three different ending scenarios. I’m doing this from memory, so I might miss some stuff.
In the first Vampire scenario, the party finds itself drawn to this abandoned church, where they’re met by a Gargoyle and a Dhampir, both of whom are brimming with Faith, as well as a collection of random vampires. They find out that God has finally gotten sick and tired of vampires and has decided to destroy all of them, by, over the course of 40 days, making them less and less able to digest blood. However, the church is a sanctuary, and the vampires in the church are all possibly redeemable. So long as they stay in the church, they won’t be subject to the wasting sickness that’s affecting all the other vampires. So, they have 40 nights to prove that they actually are redeemable. At the end of the 40 nights, those vampires in the church that haven’t been redeemed burst into flame, and those that have find themselves human again, and blessed by God.
In the second, Lillith comes back, as does Cain and the ghost of Abel. Ultimately, Cain dies, destroying the vampires, either, depending on how the storyteller wants to play it, remorseful for the killing of his brother or unrepentant.
In the third, the Masquerade is broken, and then the Antedeluvians come back, trying to take over the world. The players stop them (hopefully), but only at the cost of the near destruction of the world.
In the first Werewolf scenario, one of the tribes is corrupted by the Wyrm, and their betrayal leads to a war between the tribes that tears werewolf society apart.
In the second, the Wyrm finally makes its move, and the werewolves engage in one final war against it, in all the different realms, and finally win, but at the cost of all their lives.
In the third, the Wyrm-Weaver-Wyld triad gets back in balance, as the Wyrm is cured of its insanity. Unfortunately, since modern society is due to the Weaver being able to impose order on the world free of restraint, bringing the world back into balance means the destruction of civilization.