After Surviving the Apocalypse, I Built a City in Another World - Chapter 1284: Magic Ropes!

In a world shadowed by death, the silent realms await, home to the undead and the Grim Reaper's sanctuary. As long as death's presence endures, the great Undead Queen will return.

In the current era, people are either normal or are with ‘special abilities’. Cases related to the latter are managed by the “National Anomaly Prevention and Control and Special Species Management Office”.
Qi Zheng Emperor Sheng Lingyuan was reawakened a thousand years later after he jumped off the fiery Red Lake. Xuan Ji, a newly transferred staff to the Reparations Division of the Deviant Control Office, finds himself having to clean up the mess of a revived tyrannical monarch. The two seemed to share something from the past, but unbeknownst to them, a big conspiracy is stirring right underneath their noses that could destroy the balance of the world.

- Description from Novelupdates

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.

Xia Luobing, a famously violent sheriff, received information regarding illegal prostitution at a local hotel. She goes to the wrong room, and instead of finding prostitution, she finds a young couple talking over a bottle of wine. What she doesn’t know is that the woman has drugged the wine with a potent aphrodisiac to seduce the man.