I have only played the 1st edition AD&D rules on the table, a long time ago. But I think that there were few damage-inflicting spells that could totally miss. Normally the target gets a savethrow that halves the damage. Maybe this is different in 5e. For me a big frustration are the spell misses. Some battles go real fast, and the first rounds are decisive. So, if the first 3 of your powerful damage-inflicting spells all miss and do 0 damage (with 60% hit chance), while the opposition is pummeling you with something like 8 HP of fire and acid damage per attack, the fun quickly goes away.
Can happen of course, but I find it happens way too often.
5e has two different styles of damaging spells. Depending on what you're fighting, you might want to prioritize one or the other.
Some of them work like weapon attacks - you roll to hit and, if you do, you deal damage. These tend to be things like firebolts and rays, where hitting or missing makes sense.
Some of them (usually, but not always area effect spells) the target rolls a saving throw to reduce or avoid the effect.
