Cantrips like Fire Bolt, Ray of Frost, and utility spells like Message are useful for combat and support. Spells like Feather ...

but they're still likely to be outshone by DnD classes specifically designed to do those things. Wizards and Warlocks can access far more powerful damage-dealing spells, and the strikes of a Fighter, ...