Honestly, I feel like a lot of the hate Sheldon gets is unjustified

From the beginning of the show, we see that Sheldon obviously struggles understanding social cues. From not understanding sarcasm, or when his teachers are being passive aggressive, or other social situations. He obviously has an intrinsic issue with recognising other people's emotions and mood, as demonstrated during the study, where he entirely lacks emotional intelligence.

A lot of people use the episode where Sheldon and Missy got into a fight after she'd broken up with her boyfriend (Marcus) as an excuse to hate him, because of the comment he made to Missy. He said something alone the lines of her having attitude problems and maybe that is why she can't hold a boyfriend. Obviously that was tonedeaf and wrong, but he doesn't understand the implications of saying that. He was wrong to still enter the room after his dad specifically told him not to, and not bogging off when Missy told him to, but you can't hold him accountable for things he says without the knowledge that they can be hurtful.

Him calling MeeMaw selfish was also stupid and wrong, but then later you see him realise in the bus that it was actually his fault, and he took accountability for it. He didn't understand at the time that he was being the selfish one, but he did later on.

Also a lot of people pick bones with him for not appreciating George, but nor did Missy at times and nor did Georgie at times either lol. People only care when Sheldon messes up and fail to contextualise it. Every character has their flaw.