Lordesat, if you think goblins are the most useless, then you probably haven't played against a smart Orc enough. Goblin mages, with a quantity of 700 (approximately) or more, can effectively block hero spells! Especially Necromancers don't like that!)))
And regarding warriors:
1. I'll give an example for resurrection under vampirism: peasants, fairies, gremlins, etc. It's easier to resurrect them!)))
2. I think stalkers are the coolest, because of their overpowered invisibility!)))
3. You say warriors are good for taking down stupid neutrals? Which ones are you talking about? Zombies? They usually don't make it very far. Gargoyles? Warriors protect ranged units very well, with their "wall of shields" ability or the "no retreat" ability. Warriors fight well against creatures of the same level, except maybe stalkers or magical damage from fairies... For me, warriors are a super unit; in skilled hands, they are an excellent unit.
4. When clearing neutrals, single units play the main role, so it's only situational to attack with the main stack... the same goes for Orcs; there, peasants play that role, as well as goblins, etc.
5. If you compare warriors to skeletons, it's clear that skeletons are more deadly but weaker and win by numbers... so everything is fine.)))
Sorry for the off-topic, but I just don't have the words to explain it!