Sandman is a really good answer for this. He was so entertaining. He had a weird charisma that made him very likeable despite doing very unlikable things.

"Hardwork" Bobby Walker & whatever gimmick Mike Shaw wrestles as.

Toru Yano if he counts. One of the better comedy wrestlers and very creative to boot.