Your aoe spells are grease and shatter mind. Try landing Shatter Mind on Githyanki patrol or Bulette in the underdark on a mage without darkvision. The single useful one is Thunderwave, which comes as no surprise because the main value is the knockback damage to cheese many fights with. Not a mage spell, considering my druid can also have it and still have 19 AC.
Don't need aoe in goblin camp because I poison their cauldron and that's half of their forces dead. You kill Crusher silently by the alcove and don't even involve the rest of the Goblin camp; the sleeping mobs up top you one shot since sleeping status grants 100% crit; one crit from Lazael with dip fire= dead. Or you can just pickpocket to get the 3m ring off Crusher. Goblin camp was by far the easiest content anyways. Web works with Redcaps if the saving throws go your way; I'd rather not leave that to chance. I'll moonbeam the gateway to Ethel's house and mow them down with Lazael with 19 AC; the sage doesn't even walk to Ethel's house so you just deal with the 3 melee ones.
My aoe spell list is longer than that, because I am talking about the context of the party and how the classes can work together. I have used grease, entagle, web, spike growth and fog. I actually forgot about darkness, so oops. Shatter I have never used, so I cannot comment on that. But what I tend to do is overlaying and combing spells, and this is not as reliant on luck as you assume. Web worked against redcaps, because it was combined with grease & void bulbs. They make some saving throws, but you can pull them back, and this is enough even if your ranged attacks have the dreaded 60ish hit chance. Githyanki patrol was beaten with web & grease & ranged spells too. Bulette was a bit of a special case, so I don't count that one as a 'working strategy' for now. It came up during the hook horror battle, killed two of the party, but angered the hook horrors, who then helped my party.
And I know about the poison in the goblin camp, just as I know about backstabs, dipping, etc. But I wanted to try a good old fashioned frontal attack, only with spells. And that works just fine, contrary to the claim that spells used for cc are useless.
Edit: This is also why I'd like to try Wyll again, but with a different spell list. He can get witchbolt, which electrifies water. Create water can be cast by either a druid or a cleric. Goal is to test an electrified spike growth patch.
