Enchantment 10 is also very, very powerful of going single class Wizard for some reason. But yes, Illusion is garbage.

Divination is fantastic for a dip (and multi class wizards are the way to go in BG3 imho)
Evocation is great for a dip, also good if you go single class.
Abjuration and Enchantment are great for single class only
Transmutation is good for a camp wizard
Necromancy I’ve not tested enough to have an opinion
The rest are garbage

Just my opinion but seems I’m not alone in them XD
I do strongly disagree with Zenith regarding enchantment spells, they are fight warping/ ending effects, hit a hold person and the target is as good as dead, even a tashas can totally swing a fight, they’re far more effective than raw damage. There are also ways to push your spell save DC, and if you’re an enchanter you should do so, in which case my experience is their hit percentage is more than adequate considering their power.