The high end always seems to be defensive spells though, in terms of offensive spells it doesn't really matter. There's even less options for dark wizards since there's very little reason not to just spam the killing curse which has to be avoided or deflected by a physical barrier.

About the only thing we see that's potentially more powerful than the killing curse is the blue fire protego spell from Fantastic Beasts 2.

I very much doubt that we're going any of the "ultimate" type spells like firestorm from the later movies/fantastic beasts anyway, we're playing as students. I'm worried it's just going to end up like the current Harry Potter games where they take ten stupifies until they eventually get knocked down.