Sociology is very important to study. The tools we have for it are not great, in various ways. For example, one can study people and societies by reading Balzac's writing, but the number of people who can produce that sort of thing is fairly limited. We can try to do controlled experiments, but the way we do it in practice is not great. We really really need better tools here...
So yeah, personally, I have utmost respect for the complexities involved in sociology - while at the same time I absolutely hate all the bullshit that's being done because doing actual research feels too hard.
There is no stereotypical "scientists' disdain" for those topics. It is vital to understand history, social sciences, economics, politics, and the arts. What is disdained is the way these topics are, in the present world, not pursued along more rigorous lines.
Too many people like to look good by producing grand-sounding theories about these topics, without putting their ideas through a more rigorous process to check whether they are actually true or not. Then we get a cohort of followers who believe these theories as if they were "as true" as mathematical theorems, but they are not. This wastes everyone's time, and worse.
One can certainly picture an overly-specialised scientist who doesn't know anything other than the specific field they chose - I guess this is what you mean by "excessive rationality" - but I don't see many cases of this actually existing. What I see in far greater numbers is the problem I mentioned in the previous few paragraphs, as well as people using the "excessively rational" image as a straw-man argument to attack scientists, to distract the world from their own flaws, of "not enough rationality".
However, it's too easy for bullshit-artists to hide behind this, as a way to deflect criticism of the theories that they're proposing, or the general area of work that they've chosen to pursue.
We're all human so it's perfectly reasonable to believe in something that's unproven - but then be honest about it, and explore the topic from a critical viewpoint without getting personally defensive. Unfortunately I see many more cases of this, than instances of the fallacy-fallacy.
Edit: maybe he was a nihilist, I'd tolerate nil as the only non quantitative number. Sorry for the rant, but that's what you get for anecdotal evidence.
Feynman certainly did.
There are plenty of brilliant scientists who are held back by their excessive rationality, or whatever you want to call it. Another great book on this topic as it relates to econometrics (as opposed to physics) is "The Romantic Economist" by Nicolson.