CreamCloud0
Hero
Dealing damage, IMO, for the most part should not be magic's point of focus and i think it's a bit of a shame it has come to be seen for blasting first problem solving second, it's focus should be utility or facilitation, and the directly offensive spells that do exist would do well to fill utility/problem solving roles for combat, it would be interesting to see a TTRPG that has a long list of spells like DnD but only ~10 of those are levelled offensive spells,One new consideration I learned in this thread is the point that strong attack cantrips reduce the need to "load out" spell slots with nukes. I've never liked the infinite offensive cantrips, but I hadn't really considered this aspect of it. (Then again, I don't like spell slots, either.)
Combined with the sheer variety of utility spells, and their specificity*, I've long thought that utility spells and attack spells should somehow be treated differently, for exactly this reason. I don't think the choice between the two is an interesting one to have to make. Making utility spells rituals (in D&D) would be one solution, but that would also make casters even more useful outside of combat, which some people would hate.
I like how Shadowdark does it (surprise, surprise): instead of spell slots, you make a casting check, and if you fail you can't use that spell for the rest of the day. So different types of spells don't compete with each other, except in the sense that you pick which new ones you learn at when you level up. But Wizards (not Clerics) can still learn new spells from scrolls. E.g., if a Wizard finds a utility scroll, they have the option to learn it (consuming the scroll), and then from then on that spell is available.
*By "specificity" I meant this: even if an attack spell isn't the perfect one for the situation, it still has a high probability of being somewhat useful (unless the target has immunity). But a Knock spell, say, is of no use unless the problem to be solved is very specific. So the choice between Lightning Bolt and Fireball is not the same as a choice between, say, Knock and Alter Self. You just need a LOT more utility spells to be fully prepared.
maybe magic missile, chromatic orb, thunderwave, ray of sickness, rime's binding ice, wall of fire, cloudkill, chain lightning, whirlwind, power word: kill