Or a cross/bow, sling, or even a net. Shunt it off into dimensional space and bring it back as anything I guess. Might have some synergy with a sling and the Magic Stone cantrip (EEPC). It should in theory add to-hit plus of the sling to the pebble, but not to damage. Maybe. It doesn't say it removes the weapon's bonus, but it does say it's a ranged spell attack, so would the launcher + count?
It seems like Magic Stone would ignore the launcher's properties all together. So no Flame Tongue or Frost Brand sword/*Sling* and Magic Stone combo. Probably. It's a DM decides job, that one.
Might also be a nice way of getting mêlée-only mods onto a ranged weapon if 5th ever goes down that path. Flame Tongue/Frost Brand should work fine as bows or slings by their wording without the combo above. Could make for a pretty scary amount of damage with Hex on top of it all. Lots of +d6
Actually, are there any really weird nets with binding features that you could rather dubiously bring back as mêlée/ranged/thrown weapons? I can't find any in the DMG, but maybe in the play test or published adventures.
Dwarven Thrower could be nice as a larger weapon.
There's also the chance to do SA damage or to use things as Monk weapons that you normally couldn't use (just change them to the biggest finesse weapon you can).
Or polearm/two-hand anything for the Polearm Master/Great Weapon Master feats.
I'm surprised it hasn't been mentioned more often as a benefit of Pact of the Blade, now I think about it.