I don’t know about that, but he was sure one co-dependent motherf*cker.
When I saw The Last Tempation of Christ, I thought he came across as a parnoid schizophrenic–hearing voices, delusions of grandeur, paranoia, the whole bit.
What do you mean?! I get out and… Oh, you must be talking about that Doper from Amsterdam. 
Great thoughts on Holmes’s psychology. And thank you KarlGauss for the link to the article on the Milne characters.
Ebenezer Scrooge suffered from Paranoid Schizofrenia with all those ‘visitations’ and worrying about his money.
What about Kirk and Picard? (We all know about Spock.)
All of this may be true (except for the condoms, which Bond clearly doesn’t use). However, I think his problems are somewhat more complex than instinctive sociopathy. We know that his parents were killed while he was a child; as a result, his development with respect to authority figures seems to be stunted. He’s both defiant of them, and yet beholden to them. For all of his several threats to resign from Her Majesty’s Secret Service he always returns into the fold.
Also, it is noteworthy to observe his taste in women. He finds readily accessible, willing partners somewhat disinsteresting such as Bibi Dahl, Kara Milovy, Lupe Lamora, and Miss Moneypenny (especially the Caroline Bliss version), and when he does deign to sleep with a readily available woman, such as Jill Masterson or Domino Derval, he affects a very bored, detached demeanor. On the other hand, he seems quite attracted to strong, defiant women such as Pam Bouvier, Melina Havelock, and future/former wife Tracy Di Vicenzo, and positively, er, stimulated by women who threaten to kill him, like Fiona Volpe, Pussy Galore, Maj. Anya Amasov/XXX, and Xenia Onatopp. I think feels an enormous amount of guilt over his parents’ mountain-climbing death and seeks out both punishment and Oedipal-like absolution from mother figures. I’m guessing that Bond’s mother was both a tall, oversexed brunette and wore the pants, rarely if ever deferring to his father for the execution of punishment.
I wonder if his alleged sociopathy isn’t some kind of detachment as a result of both his wartime and numerous torture experiences in combination with the frequent cosmetic surgical alterations he undergoes to alter his appearance and maintain apparent youth. We might also guess that he uses a considerable amount of, uh, erectile supplements which may have undesireable neuropsychological consequences. All of this together probably explains his alcoholic self-medication.
He also seems to have a bit of a persecution complex along with some amount of monomania, as exhibited by his relentless pursuit of “villians” who he believes are out to destroy the world and against whom only he actions are effective.
He has admitted, in Goldfinger, to having a “slight inferiority complex”, so it’s possible that he may be amenible to therapy and treatment, but his willingness to underrate the damage both to his body and his psyche will probably undermine any treatment program.
All-in-all, he’s really not the sort of chap you want in Her Majesty’s Service, is it?
Stranger
The God of the Old Testament seems to suffer from Munchausen’s By Proxy: in order to receive the attention and adulation he considers his due, he’s forever jeopardising and injuring his “children” before “saving” them. Just ask Job.
It makes sense to me also, and I would wonder too if Holmes’ sometime perception that “I find nothing worthy of my interest” (paraphrased) meant something more like “I’m too depressed to deal with anything.” In his day, clinical symptoms short of florid psychosis were assumed to be signs of weakness or bad character, so his ego defenses would make sure he never thought of himself as defective.
He reads people’s unconscious gestures and fleeting expressions really well, which rules out the autism spectrum, but has some schizoid personality traits, i.e. he doesn’t really like the company of people, with very few exceptions, but as long as he can treat them as puzzles to be solved he’s OK with some interaction. He’s not lonely or afraid of people, just happier when keeping his own company.
Gomez and Morticia Addams - now there’s a particularly well-adjusted couple, do you think?
Star Trek is tough. It’s like analyzing a cardboard cutout. But I’ll have a go at it:
Kirk. is. a. re. cov. er. ing STUTTerer (phew). Oh and satyriasis?
**Picard ** has some sort of social anxiety disorder that revolves exclusively around children. Infantaphobia? Also he’s not too great with the ladies.
**Worf ** had intermittent explosive disorder.
**Geordi ** suffered from an erotomanic obsession with the ship’s designer.
**Bones’ ** chronic irritability might have been a harmless character trait or a symptom of depression. Or drug abuse - maybe he was secretly hypospraying himself with narcotics.
Han Solo has a problem with authority.