My most recent character was a Storm Sorcerer. I decided to do the thematic thing and pick all the spells having something to do with thunder or lightning, or which I could fairly easily theme as being created by storm related phenomenon (like Catapult being the result of a swift gust of wind).
My two cantrips....
Shocking Grasp (touch)
Thunderclap (5' radius)
Yes....I played as sorcerer who had two attack cantrips that had to be used in melee combat. It wasn't......ideal.
My choices were to either
1. Ignore the idea of trying to model a sorcerer who's powers all relate to their origin.
2. Houserule changing of damage type to change Firebolt to Lightningboltette or similar.
3. Stick with my theme and be less than optimal.
I picked 3. My sorcerer rarely, if ever, used attack cantrips and when I was out of spells I just had to wade into melee and hope for the best.
He died trying to thunderwave three dwarves into a chasm and all three making their saves.