#2 Phantasio
Harry Del Rios has had a rather long career which has seen him wrestle in numerous promotions and that includes the WWE (then WWF), but not for very long. He had a few tryouts here and there, but when he finally made it to television, Del Rios was given facepaint, a mask, and some streamers to perform as Phantasio.
Phantasio was billed as a magician, which wouldn't have been bad if they hadn't turned him into a joke. He won his debut match by magically pulling his boxers out of his pants and rolling him up for the win while he was distracted.
That was the first and last of Phantasio in WWE as his magical act was never seen again.
Del Rios spoke with WWE Magazine in 2007 and discussed the short-lived character. Apparently, it was supposed to be a combination of the Ultimate Warrior and the Legion of Doom which doesn't really make any sense... at all.