Cryomancer
Arcane
Many games have magic dangerous in lore but safe in gameplay. The most iconic example is WoW. Fel magic is in lore extremely dangerous. In gameplay, is exactly the same of Arcane magic. A good example of magic being a dangerous is from Conan Exiles. A bad example is from Age of Conan, from the same developers. Some iconic RPGs only have dangerous magic for very few spells, like summon elemental in BG2 which can be turned against the caster. Warhammer Online implemented the magical backlash mechanic for Bright Wizards and Sorcerers, spamming fire/dark magic left and right can be devastating but more the caster uses, greater is the chance of it 'backfiring", sadly the game din't made daemon summoning from magus risky.
The new Warhammer Rogue Trader CRPG, seems to implement psyker powers in a interesting way. More you use, more the "veil" between the reality and the immaterial is damaged and weird things can happen.
The new Warhammer Rogue Trader CRPG, seems to implement psyker powers in a interesting way. More you use, more the "veil" between the reality and the immaterial is damaged and weird things can happen.