Arifureta Shokugyou de Sekai Saikyou (WN) - Chapter 535

In the age of Mecha for everyone, people could travel to the Endless Abyss to gather materials, enhance and forge their own Mechas, and thus wield the power to destroy heavens and earth.Jiang Chen had transmigrated and awakened the talent [Undying Barehand]. Once his Mecha shattered, he could permanently absorb its power and attain a multiple enhancement.…At the bottom of the abyss, the ancient demon god exerted great effort and finally broke the titan Mecha, but from the shards extended a hand that held down its head.“Congratulations, you’ve unlocked my restraints.”

In a realm where even the faintest shadows whisper untold tales, I came to realize that the forgotten often hold the most powerful narratives.As an avid admirer of the world's most beloved series, I never imagined that one night's rest would pull me into its very fabric.“Why on earth am I stuck in this world? And why, of all people, am I him?”I had become Arthur Nightingale—Class A’s most unremarkable student. A magic swordsman barely worthy of mention, ranked 8th among the first-years. A mere footnote in the grand story.Still, with this body’s abilities and my own insider knowledge, I figured I could carve out a peaceful life. Or so I believed.“This was the only way,” the voice repeated, resolute. “The only way to stop her.”Little did I know how truly unique Arthur Nightingale was—or the path this journey would force me to take...

A young Brave walked out of his village, gathered companions to his side, defeated the Great Demon King, became famous, then came back with beauties in hand! This was a legend that appears in the world of Seyrol every 200 years!

Our protagonist, however, isn’t a Brave. Even so, for over a thousand years his figure has loomed throughout its history.

Unwittingly, the name of the Red-robed Priest began to resound throughout the world. Red-robed Priest’s legend included extraordinary sword techniques and magic, erudite knowledge, and an almost prophetic ability to lead young Braves toward the proper path. People of the world think of him as a descendent of the ancient Yellow Race which led to his omnipotence. In essence, however, this was just the characteristics of the profession known as ‘Noble’.

- Description from Novelupdates

Talented in Magecraft but useless in physical combat?