"the witty and charming Sherlock Holmes" - LOL! I've been a fan for over 50 years and never hear Holmes described that way. BTW, criminal investigation was mostly luck or coerced confessions way back when Holmes was created. AC Doyle raised criminal investigation to a science which impacted greatly on real police work.
I've read Christie's Poirot and of course, everything about Holmes, so I'm definitely on Team Holmes.
Interestingly, House's TV character seems to based on Holmes, and especially having a sidekick, Wilson (Watson).
Probably TV detective Columbo was based somewhat loosely on Poirot.
I should have put quotes around it to convey my sarcasm. House's character is very much like Holmes, I agree. My mom is a huge fan so I've watched it a few times. I'd never considered Columbo based on these two. He is definitely more Poirot than Holmes, but in a limited way. It might be because I love Columbo, but I think he's his own unique character. And yes, luck and coersion were the means of getting a confession, but I'm speaking of my favorite parts of the stories after the detectives had solved the case. When explaining how the crime was committed and how they reached their conclusions, each detective relied on different things. Holmes was defintely a true old school investigator, relying almost entirely on facts. Poirot relied on hunches more often than not, and followed those to see if the facts supported what he observed.