Thanks for good answers. On one hand, yep, if you have STR or use Finesse weapons, there's damage-output advantage to weapon use. On another hand, dagger is the only simple weapon with Finesse, and TWF means no shield. On another hand, cantrips are mostly ranged, with infinite ammo and none of the high-granularity requirements of ranged weapons (costs money, is one more item to carry around, requires two hands to reload*, time to string/unstring a bow, some people object to you carrying a weapon into their territory, etc.)
A spell requiring a ranged spell attack is a problem if someone's engaging you in melee. Does the same apply for a spell which triggers saving throw? If not, then that's a factor in attack cantrip selection, eh?
So there's reasons to wield mundane weapons, and also, sometimes, reasons to use a cantrip, and that's IMO ideal, because then players adapt choices to circumstances.
* Does anyone allow *repeated* fire from a sling or hand crossbow, with the other hand fully in use, eg equipping a shield? I can't imagine reloading either of those without a free hand, as well as the one holding the weapon.