My only problems are with Holmes’s character. I have a hard time believing that someone who spends his off-time in a cocaine-induced daze could be so brilliant. The cocaine users I have known have not exactly been Sherlock Holmeses. This is, well, elementary.
Holmes’s epistemology is unrealistic. His remarkable power of observation provides the stories with much of their delight, but in reality observation must serve purpose. Holmes knows how many stairs lead to his apartment, but what purpose does this serve? Someone who went around noticing these things every day would have a strange mind cluttered with unimportant facts, like an autistic savant.
Another problem is his reason-emotion dichotomy. Watson the narrator says,
It was not that he felt any emotion akin to love for Irene Adler. All emotions, and that one particularly, were abhorrent to his cold, precise but admirably balanced mind. He was, I take it, the most perfect reasoning and observing machine that the world has seen, but as a lover he would have placed himself in a false position. He never spoke of the softer passions, save with a gibe and a sneer. They were admirable things for the observer – excellent for drawing the veil from men’s motives and actions. But for the trained reasoner to admit such intrusions into his own delicate and finely adjusted temperament was to introduce a distracting factor which might throw a doubt upon all his mental results. Grit in a sensitive instrument, or a crack in one of his own high-power lenses, would not be more disturbing than a strong emotion in a nature such as his.
In reality emotions can be tools to help one know what is important if one contemplates their meaning. Emotions are psychosomatic responses to values; a threat to values causes fear, injustice causes anger, etc. Emotions are essential to evaluating reality. Someone like Holmes would have a hard time functioning successfully because he would not have his own emotions to use as clues for understanding. He would be a detective cut off from some of the most important clues humans can use!
Setting aside psychological realism, or lack thereof, Holmes’s epistemology does provide tremendous drama for the stories. Falling in love would be the most disastrous thing that could happen to him; this sets up a value-conflict between love and crime-fighting, and value-conflict is the stuff of drama. (I would expect to see Miss Irene Adler return in other stories, but I don’t know.)
With the value-conflict and the plot, “A Scandal in Bohemia” is superb romantic fiction. We’ll see if the other stories are this good.