RBY: Clamp. Also walls Snorlax and tanks Tauros like no other.
GSC: Spikes. Also an offensively useful boom.
RSE: Spikes without getting Magne-trapped. Also spins and booms.
DPP: I don't know for sure what caused its lapse. My best guess is that Stealth Rock becomes the new best hazard, so a dedicated Spiker isn't really all that great anymore. Also being weak to SR makes it an iffy spinner.