I Can See Through Everything - Chapter 7

The Apocalypse is in full swing. Defiled - powerful creatures corrupted by the Great Collision - prowled the lands in search of prey. Unfortunately for them, the human race had long since retreated behind the secure walls of the Sanctuary of Everlast. During one of his regular excursions outside the Sanctuary, Alden is separated from Celeste. - his childhood friend and crush. In that moment, he came to regret never summoning the courage to confess. Somehow managing to survive thanks to some trickery, Alden awakens as a mage. Instead of receiving a normal power, he gains the ability to decay. What’s more, during his ascension, he received a vision from his future self advising him not to trust the Asterons - celestial beings who had saved his race from inescapable doom. Normally... such a revelation wouldn’t faze Alden. However, there was only one major problem with the declaration, though. Celeste was bound with an Asteron. And not just any normal Asteron... She had made a pact with one of the Divine Sovereigns.

Frank, a mercenary known for his cold ruthlessness, decides it’s time to leave the bloody world of the underworld behind. But the underworld has no plans of letting him go. Relentless enemies from his violent past keep hunting him, and eventually, they succeed—Frank is killed.But fate has other plans. Instead of staying dead, he is mysteriously reincarnated into the body of a cop in a world filled with crime, corruption, and dark secrets. With the help of a strange, all-knowing system, Frank is given the chance to live again—this time, to prevent crime before it happens.

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.