cbwjm
Seb-wejem
I like choosing my spells for magic initiate along a theme. For someone initiated into the mysteries of the children of flame I might pick control flames, fire bolt, and burning hands. Burning hands won't scale at all but it fits the theme. Another use might be a sage who picks up light, mage hand, and comprehend languages to aid them with their studies.
However, if you just want any old spell then I would suggest absorb elements or shield for defensive options. Unseen servant I think would provide some use throughout your career, so would detect magic. Many people tout find familiar as the spell everyone should have. A 1/day cure wounds or healing word would be useful to bring someone back up from unconscious. longstrider for a speed boost or speak with animals for intelligence gathering. I think disguise self would also be a good pick.
However, if you just want any old spell then I would suggest absorb elements or shield for defensive options. Unseen servant I think would provide some use throughout your career, so would detect magic. Many people tout find familiar as the spell everyone should have. A 1/day cure wounds or healing word would be useful to bring someone back up from unconscious. longstrider for a speed boost or speak with animals for intelligence gathering. I think disguise self would also be a good pick.