Thought of another system that might be a better impliment.
Let set the stage with the hypothesis that we are using a level type system of spellcasting were a level 1 spell needs 1 successful roll, level 2 needs 2, 3 needs 3 and so on.
What if we would use a faliure chart, marking, for example, number 1-18.
So you roll your basic, I dunno, 'light' or whatever. Demands one success and you fail. Out comes the failchart. You roll 1d6 (because the spell demanded 1 successful roll) and consult the effects 1-6.
1 is a simple dud, nothing happened. 6 could be like a minor missfire, seering your hand for 1-2 damage?
Nothing to harsh, but as the spells demand more successes, the more dice you roll 'if' you fail.
Thoughts on this?
I like this and have been thinking of a very similar approach, but I fear it might slow down play too much, requiring the extra roll. In my mind, I would prefer to roll once for the spell. If the roll fails, the misfire is determined by the existing pool somehow.
Current thinking is that the highest die in the pool determines the severity of the misfire. The severities increase with the level of the spell. So you have a misfire table with 1 through 5 as rows (highest die rolled), and the columns are spell levels. Make sense?
I make YZE games (https://drivethrurpg.com/browse.php?author=Matt%20Kay) and produce predominately Free League content on my YouTube channel (https://youtube.com/@3skulls)