MechaTarrasque
Hero
Since sorcerers don't currently have an official gish subclass (a couple of UA ones that didn't make the cut), you might as well leave it off for them (and if there is an archery gish sorcerer subclass in the future, it sounds like future sorcerer subclasses might have bonus level 1-2 spells). Warlock and paladins are built around melee weapons, so you can skip those. The spell has someone's name, so it would be good for wizards (and useful for eldritch knights/arcane spell thieves). It seems tailor-made for rangers, and pretty much all ranger spells are druid ones too. Bards can learn spells from any class, and this doesn't seem extra bard-y, so I would let them learn it via magic secrets. I think that just leaves clerics, and this doesn't feel generically very cleric-y to me, but it would be a good domain spell for a hunting domain cleric.