Most of those other schools have some non creepy use. For me, mind "assault", to use a less triggering word, is essentially always scummy.
The issue I have is that people want to make an exception for Necromancy, making it the only evil school of magic, while ignoring the REALLY DARK GREY school of Enchantment. Because, enchantment is a school that has perhaps the fewest good and neutral use cases out of all of the schools of magic.
A bit late, but I'd like to take a moment and point out that Bless is an Enchantment school effect. If Bardic Inspiration was a spell, it'd also be Enchantment. Heroism. Sleep and Catnap have beneficial uses as a sleep aid. Zone of Truth has uses in a court room. Calm Emotion is drug-like, but it can be used as the equivalent of a mood balancer for, say, someone who's bipolar.
D&D is a game about fantasy violence, so it should be no surprise that most -published- spells aren't nice. But every school has positive effects, including Enchantment and Necromancy. And I'm sure there's many spells that exist in world that we just don't see, because they're useless for adventurers. Imagine the number of wizard spells that would exist for maintaining books and libraries.
Depending on how it's works...
I always felt like having an army of mindless undead would be great for an economy.
Like have them build roads, pick crops, deliver packages, work in steel mills, and other mundane chores like that. Put a small horde of undead rats in a hamster wheel, stick it on a cart, and you got yourself a car.
Assuming your not torturing someone's soul or such.
In 5e, it seems like that the undead, including those from the Raise Dead spell, are created by capturing a "dark spirit" (whatever that is) and shoving it into a corpse. The "dark spirit" then animates the zombie/skeleton and is magically enslaved to obey your command until the spell wears off. At which point, the dark spirit does its own thing, usually attacking the nearest living creature.
Necromancy like this is evil in that it creates murderous creatures that have to be kept under magical domination or they'll turn on anyone living and try to kill them. Which... to be completely fair, is kind of what you do to create most golems, just with elementals being used instead of "dark spirits." Anyways, the point is that undead creation involves non-consentual binding of spirits and said undead being a hazard. Individual tables may vary.