The most gruesome thing I used was actually from the setting. In Rokugan there's something called the Living Darkness, the last remnant of the Nothing that was the universe before time. It's sentient with the goal of returning everything to the Nothing by consuming things, especially creatures. It's unrelenting, never stopping until it consumes everyone that learns of its existence. It's a campaign killer, since the PCs can't ever stop it, they can only escape and delay.
This campaign (one of my best) ended as a tragedy, as it slowly hunted down the party. In their home base, it sought out each PC to prey on their weakness, but each time giving a hint of their true target: the wife of their lord. One by one the PCs were either killed or consumed, with one managing to escape with his son (betraying the party and his lord to flee). The last PC managed to overcome his trap with the aid of his dead brother's spirit, but misunderstood the hint, believing the target to be his lord. He searched for the party to aid him, but found only bodies. He then went to his beloved, the lord's wife (who used to be a PC), hoping that her Void magic could hold it at bay. He came in as she was being consumed, and realized that if it obtained her magic, it would be immune to it forever. He went up and cut her down before she could be consumed, only to have guards come in soon after. He ritually committed suicide for his crime, ending the campaign.
A flesh golem made entirely of children.
One PC once made his exit from the campaign by getting flushed down an orc toilet.
Another time, members of the party were exploring a Necropolis and fell into a pit of infant zombies.
Oh and once, while the PCs were paralyzed and helpless, a half-fiend gnome pried open the skull of a beloved NPC and scooped out his brain to eat some.
I love the way you guys evil!
Sometimes it is the little things.
Absolutely! I took over GMing a group and ran a similar adventure to one run by the prior GM, where they had to enter the lands of darkness, which can corrupt the soul in addition to killing the body. Afterwards everyone talked about how terrifying it was, especially after the death of a PC. The other GM claimed I must have modified the monsters, and I explained that I hadn't. I just used better descriptions to provide a greater sense of dread, whereas he was fairly vanilla. The PC who died ran ahead of the party to fight two ogres by himself, in a game system that can kill you in 1-2 hits, so he deserved being squashed to a pulp!