He's often brainy, often works in the sciences or in government, is usually Hollywood Homely or genuinely unattractive. He's bitter toward women, even, or especially, the ones who find him attractive. Usually villains or anti-heroes. Examples: Munch on the first season of Law & Order Special Victims Unit, Owen on the first season of Torchwood, and at times, Xander and Spike on Buffy the Vampire Slayer.
Hello, Unknown Troper. You'll need to get known to lend a hand here.