Horwath
Legend
maybe if there is no saving throw, it would be a good spell. Very good even.Actually conjure barrage is not that bad anymore. Force damage is solid. 5d8 is 3rd level benchmark damage.
So it is not way behind a fireball (5-40 force damage, no friendly fire vs. 8-48 fire damage, friendly fire).
Yes, wisdom is not your primary stat. It might be your secondary however. You should be able to afford a 14.
I would probably not prepare it, but is a fine spell to use.
Do I like it to be used with a melee weapon? No. A thrown weapon at least. Now I Imagine throwing up a dagger that splits and hits a group of goblins, killing them all in one go. Not bad at all.
Or if it worked similar to lightning arrow. you make attack roll vs all targets. Half damage on a miss.
Might encourage to use Hide action before using your big guns to attack with advantage.