Well for Skyrim I agree somewhat, but before the game was dumbed down spells in mysticism like manipulating objects, illusion, spells that make people like you more. Im sure theres some old timers that can think of tons more.
Daggerfall spells for Mysticism:
Banish Daedra - Except for the name "Daedra" this is non unique. Banish undead, Elemental is very common.
Detect
* - Generally it is Detect Life or Detect Undead, then you have your non-magical tracking in some games (EQ)
Far Silence - Silence, pretty much a staple of RPGs.
Fenrik's Door Jam - Ok, this is pretty unique being able to jam a lock but it is kind of pointless.
Holy Touch - Inverted Harm Touch, Paladins generally have this. Dispel Undead
Holy Word - Paladins generally have this. Dispel Undead
Null Magicka - Dispel or Purge, common.
Open - Fairly rare for magic users to have this.
Recall - Basic RPG feature. Bind Soul, Gate, Hearth etc.
Silence - Basic RPG feature.
Soul Trap - This is in a lot of games in some capacity particularly ones with "warlocks" or Dark Wizards.
Spell Reflection
2 - Barrier, Wall, Reflect - Basic
Tongues - Contingent silence - basic
Wizard Lock - Fairly unique but normally you can just use keys.
Wizard Rend
2 - Does damage and paralyzes equivalent to Stun. Pretty standard spell.