The Ugandan Destroyer was always a favourite of mine.
"El Terrible" is another good one.

Most over used of all time has to go to "Sugar"

I always judge them by how good they sound when the ring announcer rumbles em off. Evander "The Real Deal" Holyfield was awesome in this respect.