I do not think Snape is appealing, either in print or on film. In the books, you get enough detail to consider him, ultimately, pathetic. On the other hand, his hair is clean in the picture, and his voice is ... something.
I loved him in “Robin Hood, Prince of Thieves.” I have never seen him in anything that was disappointing.