Magic Missiles are kinda special case ... especialy in BG-3 where with only two artefacts you can almost triple its potential damage outcome.

I was thinking about spells like Witch Bolt, or Acid Arrow.
Well. Witch bolt is more powerful, or atleast more economic, over a long fight since it can make continuous damage over several turns without wasting spell slots but is a bit underwhelming, especially in BG3 where few opponents will last the full duration of 1 minute ie 10 turns and concentration is easily broken plus that spell slots can be easily recovered after every fight.
Melf's though....yeah, it sucks in comparison except that it's guaranteed damage even on a miss.