The Royal Rumble match has propelled many wrestlers to superstardom, but unfortunately, some of them have been stinkers.