I was going to say Hannibal Lector but I don't really see those movies as horror more thriller/psychological thriller.
Anyway, another villain who I thought was great was Mick Taylor in Aussie horror movie "Wolf Creek" John Jarrot was very convincing in that role especially since he's never played that kind of part before.