I seriously think Frank Horrigan is one of (if not the) most badass villains ever. He looks so incredibly sinister, and I think they did a really good job on his voice effects in Fallout 2.
In case you don't remember, here is a little screenshot and sound clip of Frank Horrigan...