Stat this marsey

I haven't looked at 2nd edition DnD for years - and that is what the old DnD games (Spelljammer, Death Knights of Krynn, ...) used so not really sure what you can do with magic missiles. It does have the advantage that you don't need to roll to hit (no (ranged) touch attack) and immunity to force damage is quite rare.

In high level Pathfinder (1st edition, what I play) it's also not really useful. You can pump it up with metamagic but then you are using a higher spell slot which negates the "only lvl1 spell". You can add one metamagic though for free with metamagic rods, so not super bad. It also allows no saving throw (which makes it superior to most low level damage spells) since your spell DC doesn't increase with caster level only spell level. That said you honestly use low level spells for utility in high level play and not for combat.

It's iconic and has its usages in early & mid level play, but there are better ways to play a caster ;) Discern next of kin is way more fun to annoy your GM