We had an absolute blast when our group played through Separation Anxiety in Fear's Sharp Little Needles for Call of Cthulhu. I modified the adventure a little bit to suit the group. Content Warning - Madness, Abduction, Harm Against Pregnant Women, Child Sacrifice, Extreme Violence
The party tracked her to a rural farmstead where they found crazy Nylarthotep worshipping hillbillies performing a deadly ritual.
They snuck around with a bloodhound, fought hillbillies with machetes and chainsaws, and found her chained up in the farmhouse. The baby had been removed, and the party contemplated putting her out of her misery. They fought over it, but ultimately decided to spare her. They found the concerned father fighting hillbillies outside after they'd killed their dog. They tried to stop ritual by lighting the cornfields on fire, but ultimately the kid was sacrified to summon the avatar of Nylarthotep.
We lost a party member to a chainsaw wielding hillbilly, and the concerned father dueled the monstrous avatar his son was used to summon for way longer than he had any right to. We were all amazed he survived so long, narrowly avoiding killing blows from two hillbillies and the monster itself. So it was devastating when his crazed wife emerged from the farm house and ran him through with a machete - killing him. The group couldn't bring themselves to kill her in turn.
The group burned the place to ground and their federal agents allies helped clean up their mess - when the dust settled both Ziggy and his cousin Flynn were dead. His wife Susan was mad with grief, and their unborn son had been sacrificed to a dark god.
The adventure had everything - crazed cultist hillbillies, massive fires, evil Nylarthotep avatars walking in corn fields, chainsaw duels, betrayal and character death. To this day, it was the most memorable session of Call of Cthulhu we've ever played.