In the Second Generation of the Trench, He Changed To the Ruanfan Script - Chapter 22:

The story is about a a hitman, Who dies because of his own recklessness and transmigrates into a game he used to play after his retirement as a hitman.I'm not gonna spoil any further, but i might answer few of your questions.Is MC overpowered?Nope, he'll become strong over time and all battle he'll fight will be because of his effort and techniques.Is there magic and adventure?Yes! It have both magic like normal isekai with adventure and fighting with monsters and many other things. There are other important things like “Essence Stone” But let's talk about it in the chapters.There will be harem?Not really, He will be in contact with many beautiful female and males but one waifu but i haven't decided yet.All i can say is, give it a try, I'll try my best to make it worth your time.

The protagonist, Punk, is a cautious, cold-blooded, and ruthless Mage.

His goal is always his top priority, over feelings or morality. When unnecessary, he doesn’t like to act like pigs to eat tigers; there are almost no life and death struggles, sometimes risky but steady progress. No strong enemy everywhere, Instead, Punk is always a strong enemy of others.

And he has a very keen interest in the secrets and teachings of the Netheril civilization.

I can be the main character even though I’m not a hunter. Kang Moo-hyuk succeeded in all the raids with his genius and rose to the position of Strategic Team Leader despite not being a hunter.But one day, he got diagnosed with a terminal illness called “mana addiction”, and even got involved in a power struggle within the guild. With only a few days left to live, he decided to do everything he every wanted and set his passions ablaze. And he chose the tier 1 “Taesung Guild” to do so.But how can Kang Moo-hyuk grow the guild with Joo Se-ah when the rest of its members are amateurs?