Why is Sherlock Holmes in adaptations often portrayed as an asshole?

It's something I was wondering for a bit, for a long time I only knew Sherlock Holmes from many adaptations and not from the books. He often is portayed as rather cruel and not intrested in people (especially in the BBC show) so i expected him to be just like that in the books, but to my suprise he is WAAY more chill in the books? Maybe i just haven't read enough i only read a few but i was really suprised? Like yes he is sarcastic and kind of snarky sometimes but i would never characterized him as uncaring, he is not even that rude? So i was wondering is there a reason why he behaves like that in adaptation? Are there like books where he is very visible uncaring and rude?