My most recent wizard is Vaeris Lianon, a 13th level (pre-Tasha's) bladesinger who was in Avernus. Both as a bladesinger and in a place where most foes had magic resistance and/or elemental immunities, her spell list differs from a general usage wizard. Oh, and Dragon's Breath was to do on her familiar, Onyx. Please note the Ritual list - that was an important part of the utility without needing to take up spells prepared.
Here's what she had prepared the last session of play, when we dealt with saving Zariel and then fighting Bel, the ex-patron of our Warlock. I'm just cut-n-pasting from my sheet so it also has my quick notes so I don't need to look up spells at the table. (C) means concentration, (R) means reaction to cast, [ba] means bonus action to cast.
Cantrip
Booming Blade: Make melee attack with +2d8 thunder, if target moves takes 3d8 thunder damage
Lightning Lure: Range 15’; STR save or pulled up to 10 feet straight towards and take 3d8 lightning damage
Mage Hand: Very handy. Up to 10 lbs. Better than a 8sp lady of negotible virtue.
Message: 30’ range; point at someone – talk and get reply, no one can overhear.
Mold Earth: 5’ cube dig
Prestidigitation: Yer a wizard, ‘arry!
1st
Absorb Elements ® take acid, cold, fire, lightning or thunder; Resistance, and +1d6 damage of that type next melee hit.
Feather Fall – Normally 5, Chris allows this to be upcast for more.
Mage Armor 8 hours, AC 13
Shield ® Triggers if hit; +5 AC until start of next turn & ignore magic missile
2nd
Cloud of Daggers © 4d4 Slashing in 5’ cube (enter or start). Upcast +2d4. Note: no save or attack
Dragon’s Breath [ba] ©, 1min. Target creature can spend action to 15’ cone 3d6 breath (acid, cold, fire, lightning or poison) DEX save half, upcast +1d6
Knock
Misty Step
3rd
Fly © Upcast +1 targets
Lightning Bolt – 100’ x 5’ line; 8d6 lightning, DEX save for half
Counterspell
4th
Evard’s Black Tentacles © 20’ sq, diff terrain. Enter/start, DEX save or 3d6b + restrain. Start restrained, auto take 3d6b. STR/DEX check to free self.
Greater Invisibility © 1 min Invis. Can attack, etc.
Otiluke’s Resiliient Sphere – Enclose creature Large or smaller. Unwilling DEX save. Nothing can pass thru.
Fire Shield
5th
Transmute Rock - Non-concentration large battlefield control that doesn't have to go against their Magic Resistance.
Wall of Force ©
Steel Wind Strike – 5 targets, melee spell attack each target. 6D10 force. Teleport within 5’ of one of the targets.
6th
Mass Suggestion ©
Tenser’s Transformation © 10min, 50 tHP, Advantage/+2d12 force all weapons, prof STR & CON, no Spells. All prof. At end, DC 15 CON or
True Seeing
7th
Forcecage
Crown of Stars – 7 motes, 4d12 radiant, bonus action
Rituals – 10 minute cast w/o using slot
Alarm, Comprehend Languages, Contact Other Plane, Detect Magic, Feign Death, Find Familiar, Identify, Leomund’s Tiny Hut, Magic Mouth, Rary’s Telepathic Bond, Tenser’s Floating Disk, Water Breathing
Note: Feather Fall was changed by our DM to allow it to be upcast to cover more people, since we had a party of 7. This is again a specific pick because were were having to climb back up to Elturiel, and then fight a flying foe.
Spells like Cloud of Daggers only make sense in the elemental immunity and advantage to all saves that we met in Avernus. Lightning bolt was my one AoE spell (earlier levels: Thunderwave) against non-fiends, picked because it seemed everything was immune to fire and because with such a large party someone would always beat me on init and run up so I needed to be selective on targets.
Knock - we had no rogue or anyone with skills to deal with locks or traps. Besides sending the barbarian in first.
Otiluke's could also be used on allies about to die.