A busted stand which can restore objects and people to their original state, and a bunch of other things that Araki forgot...
Crazy Diamond
Undead Burg
Taurus Demon
They were created when Professor Utonium accidentally added an extra ingredient to his concoction: Chemical X.
The Power Puff Girls
Killers are Quiet, Skin Ticket, Circle
Slipknot
Col. Shepherd is one of the main villains all along.
Call of Duty: Modern Warfare 2
It just works.
King Crimson
Farron Keep
Abyss Watchers
In 2039, Terry's father is murdered. He then takes up a fearsome mantle from an old man living in a decrepit mansion.
Batman: Beyond
No Remorse, Trapped Under Ice, Dirty Window
Metallica
343 Guilty Spark seeks to defeat The Flood by eradicating all life.
Halo: Combat Evolved
In the form of a flying beetle, it uses intense speed and precision. Its tarot card suggests the end of a journey.
Tower of Gray
Smouldering Lake
Old Demon King
The everyday antics of six misfit elementary school children during lunchtime, and their everlasting struggle against the nasty Ms. Finster.
Recess
Titan, Between Two Worlds, Howlin' with the Pac
HammerFall
You have been Revan the whole time
Star Wars: Knights of the Old Republic
Once the user is killed, this tiny stand relentlessly follows its target(s) to murder them. RIP, Big Papa.
Notorious B.I.G.
Darkroot Garden
Moonlight Butterfly
Join Sam, Alex, and Clover as they undergo secret missions to save the day.
Totally Spies!
Return to Flesh, Absolute Hatred, Coffinfeeder
Cannibal Corpse
"Would you kindly?" is your trigger phrase into being mind-controlled
Bioshock
Easily one of the most bizarre stands, it has the ability to create the ghost of a music room. This room is only accessible through an invisible crack on the staircase wall in Green Dolphin Street Prison.
Burning Down the House
Dark Chasm of Old
Darklurker
Betrayed by the humans they were sworn to protect, these creatures now inhabit Manhattan. They are stone by day and warriors by night.
Gargoyles
Blur the Technicolor, Thrust!, Real Solution #9
White Zombie
Paxton Fettel is your brother, and Alma is your mother.
F.E.A.R.