comments:
https://j-novel.club/series/the-reincarnation-of-the-strongest-exorcist-in-another-world As other people have mentioned, Mushoku Tensei / Failure Frame / The Magic in this Other World is Too Far Behind Doesn't fit, but close: https://www.amazon.com/Notorious-Talker-Worlds-Greatest-Light/dp/1648276105 (always at a disadvantage at close range, but keeps going melee anyways for one reason or another) https://yenpress.com/titles/9781975351519-king-s-proposal-vol-1-light-novel (technically the protag is male, and technically he fights with spells most of the time, but, well, there's a gimmick) Protag is strong at melee range w/ physical enhancement/martial techniques, but the story still revolves around casting big spells: https://j-novel.club/series/the-greatest-magicmaster-s-retirement-plan https://sevenseasentertainment.com/series/disciple-of-the-lich-or-how-i-was-cursed-by-the-gods-and-dropped-into-the-abyss-light-novel/ Demon Sword Master of Excalibur Academy (iirc) The Misfit of Demon King Academy (haven't read it, but iirc)