The Visitor episodes were some of the best. I loved the concept of his character about as much as the Q.

But then with the right acting and writing many different types of characters can become compelling - see Quark, for instance.