Outside of his "Movie Debut" with Chyna, I've always enjoyed and liked Sean Waltman. Sure, he has his major issues with drugs and as a result would likely never be brought back, but that aside I enjoyed his Wrestling career, not his personal life.
Waltman was an inspiration to me, inside the ring, because he was the first "smaller" guy that I seen make it in this business. Guys like Waltman, Kidman, and Kendrick are reasons to give the smaller built people of the world hope that they can still find a way into the business.
In my opinion, Waltman helped Kane grow when he was in a hole. I enjoyed Kane w/ X-Pac. I enjoyed the feuds the Kid would have with Ramon, then the team they formed. Same with his teaming with Triple H., then feuding with him.
I'd love to see him back, but unfortunately I'm more confident in saying I doubt it'll ever happen.