Psychopaths make best heroes? That's bullshit. What heroes do to be considered heroes is almost always generous, with risks, costs and sacrifices to themselves. Psychopaths are selfish and with no interest in others people's well being unless they have something to gain, by definition. It's the villains who are modeled with psychopathic mindset in stories everywhere, not the heroes...
Also, yeah...James Bond is a fictional character. And even so he's no psychopath.