So, for me at least, I think that most of the attraction comes from the personality traits of the Sherlock character.

Yes. This.

And surprisingly, in the Sherlock fandom, this isn't really that unpopular of an opinion. Sorry shyfoxling you're going to have to do better to shock us. :))