Not like that, but in science and some professions people do use special skills in logic and observation. 

I think a more interesting question is, would society really be fascinated with him, would he attract followers? Especially in the modern era when we feel like we've seen it all, and there is nothing out of the ordinary about narcissism or poor social skills. (That was something of a novelty in socially-rigid Victorian England, and his methods were probably more cutting-edge then, too.)

The modern Sherlock isn't terribly different from, at least, a lot of other modern crimefighting characters.