Our lead is born with a lot of mana, but it's too much for him so he can't use magic. This makes his family hate him, because he's a failure and his mother died during his birth. But using the looked down on sword skills he becomes a great hero in a world that only values mages not strong hero/ knights like him.
The Heroic Tale of a Failed Magic Sword User