Biggest Comeback has to be Mark Henry, surely?
The guy had 15 years of meaningless feuds, gimmicks and matches and was pretty much written off as a failure.
Look at him now, one of the top heels in wrestling.
Could say exactly the same for Bully Ray in TNA too.