I usually visit this thread before caffeine. I start to read, then my eyes get blurry. Well, it’s before caffeine, my eyes are blurry, and I’ve at least scanned the posts; so let’s see if my fingers work…
I’m a big fan of James Bond (as you may know from several references in other threads – and I’ve read most of the books). I also used to read a lot of Sherlock Holmes and enjoy the series that starred Jeremy Brett.
Comparing Holmes and Bond is difficult because their cases were so different. Holmes might find out how some red-headed men robbed a bank, but Bond finds out how SPECTRE is engaged in nuclear terrorism. I think Holmes has it over Bond as a detective. He clearly figures things out much more rapidly and thoroughly. In the books and films, Bond often seems not to figure things out until it’s too late for him to avoid a situation. Holmes seems to figure out a situation and play the evil-doer into his trap.
On the other hand, Bond is better in a fight. He is a military man who went on “special missions” in WWII. (Time is a funny thing even in the Bond films. There is a headstone that says Bond’s wife was killed in 1969, but Timothy Dalton would have been a little young to wed then.) As Vinnie says, “punching out a spoiled rich boy is hardly something you can compare to the many, many trained assassins that Bond not only beat up when attacked from behind, but killed with his bare hands.”
Bond also had impressive resources behind him. He had intelligence services stationed in most places he visited and an expense account. Holmes had the Baker Street Irregulars and some personal funds.
I agree that Bond was saved by dumb luck many, many times. Holmes was a little more careful.
IMO, Holmes was the better detective and Bond was the better operative.