Totally agree with you, OP, except for that this is a D&D problem and not a Larian problem. It is the case that a whole lot of spells in D&D are pointless, and on top of that the problem of being able to run only one concentration spell at a time makes many spells unusable.
It's not a DnD problem, imo; it's a computer game implementation problem.
DnD has a lot of spells that are utility based, or oddly specific, and yeah some of them are better picks than others. But the reality is that any computer game implementation of DnD - every implementation that has so far existed, at least - fails miserably at approaching the creativity and problem solving of tabletop. Lots of weirdo spells that have niche utility uses are perfect for a TT wizard. In a TT game, though, it becomes hard to think of a reason to use them.
