Just look up the WWF's roster from the New Generation era and you can get a slew of terrible gimmicks. Mantaur, T.L. Hopper, Aldo Montoya, The Goon, etc.
That said, I always have to go with Red Rooster as the worst. Poor Terry Taylor's career never recovered from it.