Ultimate Grimoire reminds me of this CYOA-like novel: https://chooseyourstory.com/story/necromancer
The protagonist in that isn't good at normal magic as well.