

If you want something really drunk and insane, the especially terrible city book Berlin By Night has an adventure sequence revolving around a Ravnos Methuselah deluded into thinking he's Caine, to put it as mildly as it could be put. Under a Blood Red Moon is a big crossover-y thing about Werewolves kinda tricked by the Sabbat into attacking Camarilla Chicago, sort of, in which you can either play Camarilla, Sabbat or Werewolves. There are some I kid you not almost straight up dungeon crawls in very early vampire with the goal of diablerizing the chewy elder center of the dungeon (they are actually titled "diablerie").

With that said, various adventures/campaigns: The Transylvania Chronicles supplements are an entire play your characters from dark ages to modern nights spanning campaign of multiple adventure sequences, though, ahm, kinda railroady to put it lightly, the Giovanni Chronicles do something similar then do a very insulting epic fail of sticking the landing in the last part ("you know the characters you played for the last 3 books? Well now play some completely new neonates and we're going to contemptuously judge you hardcore for even the idea that you would want to wrap this chronicle up with the characters you played through three separate books worth of it!"), there's also the Ventrue Chronicles. There's also a humble bundle sale going on that has Alien Hunger and Nights of Prophecy in it, as far as things you can actually run your players through. With that said, they can basically all be found on drivethrurpg at this point just click on whichever edition of vampire and look for that sort of supplement. Published adventures are honestly not really Vampire's strong suit and a very mixed bag at best.
