Goblins mostly aren't that smart to be evil in same way as humans/elves/drow. They also have natural tendency towards evil, something that the races mentioned before lack.
What you call "evil" may not be considered "evil" by the character itself. For example, you say that goblins are too stupid, but this does not prevent them from being cruel, just because it is normal for them. They don't think they're doing anything wrong. I'm sure it works for drow too. The definition of evil or good actions comes from "morality", according to moral principles, some actions are considered evil, but the fact is that the concept of morality and justice in each society is different. So what you would consider a "tragic situation" would be something for drow to laugh about.
It is surprising to me that Minthara's fate as a cleric in drow society could be tragic. As far as I know, cleric of Lolth occupy high positions in their hierarchy. She should have been respected.
lore refer to almost all of them going insane
Almost all of them? Can I ask you for a source? I want to read it.