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

A brand new masterpiece by the author of “Unscientific Beast Taming”!!!The best fantasy novels in China in 2023！The invasion of creatures from different time and space gave birth to the “Beast Master” profession, and the protagonist was selected by a mysterious “black card”, indicating that he has the qualification of a Beast Master and can contract to control pets to fight for himself!“Who could become the undisputed King of Beast Trainers in the brand-new Beast Training Era?”Royal Beast+Online Gaming+Spiritual Energy Recovery+Secret Realm

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.

Qin Zhaoyue, a hundred-year-old Soul cultivator and famous artifact refiner, dies and transmigrates into a body of 16-year-old Xi Zhaoyue, who was killed on her wedding day.

The unlucky previous owner of the body was an illegitimate daughter of an influential family and was forced to live her whole life in the orphanage. However, at the age of 16, her Guide glands were awakened and as fate willed it, Xi Zhaoyue happened to have the highest compatibility with the youngest, bravest, most handsome Major General of the Empire, a dream husband of the whole Outer Space! Finally, a loving family she so longed for was within her reach… Yet, at the wedding ceremony, her Mental sea was invaded and she died.

Once Zhaoyue figured out the situation she landed herself in, she vowed: she wouldn’t be a proud and self-respecting cultivator, if she didn’t strive for independence, for the right to live the life freely! Cultivate, refine, get stronger! Become your own person!

- Description from Novelupdates