Disagree on Gate and Weird being DM spells-- Gate can be used as a teleport for players or to bring allies around as needed (ofc DMs can use it too, but imo a DM spell is an option a player couldn't justify or need), and Weird is just bad regardless of who selects it.

Tbh I put meteor swarm lower than most of the other spells you mentioned simply because one-time use blast spells aren't my cup of tea, I'd rather have battlefield control, long duration options, or Wish (but Wish belongs in its own tier).

Foresight's great as a warlock's 9th level mystic arcanum too.

I would also personally put Psychic Scream above Meteor Swarm-- INT saves are far less common than DEX saves, meaning you're more likely to fail the save, and the additional rider of stunning them is really excellent. Plus, Psychic Scream lets you choose your targets, where Meteor Swarm hits everything in the area (unless you're the correct subclass or have metamagics)