Magic The Gathering is the champion of spells though. That game has the most amazing insane spells. Trying to find a crazy one to show.
A few off the top of my head:
Not that these aren't interesting, but in the context of RPGs, it is a bit hard to actually make spells like this. Magic is a game that ultimately is very abstract. What "life" means, what the grimoire is, what does it mean to summon a creature and what is actually summoned (is a white soldier card supposed to represent a single person, a unit or something else) is all abstracted away.
As such, it can have spells that, like the ones you posted, affect the game only through the rules, without some kind of explanation of what is going on; all the while remaining "thematically" connected to something more concrete. The nefarious lich enchantment, for instance, allows the caster to use cards in his "cemetery" as "life", which is kinda like something that a lich would do... without being clear on what either term means concretely.
While this is perfectly fine in an abstract card game like magic, it doesn't really fly on an RPG (and trying to play like this only leads to a game themed like an RPG, rather than a real one). The stuff you do in game should be resolvable to concrete actions, you can't have something exist only on the "rules" level.