I’ve never played D&D, but not for lack of interest! As such, my favorite Magic Missile Memories would come from the TSR licensed comics published by DC in the late 80’s.

I loved Forgotten Realms, where Captain Dwalimor Omen would blast away at a rampaging Tarrasque... unfortunately ineffectively!