Warlock of the Magus World (WN) - Chapter 9

He is a young man without a spirit root. It is believed that this denies him the chance at cultivation. However, a mysterious lady imparts a Supreme Demon Classic to him and from then on, he starts his path of cultivation.
He undergoes a total transformation to emerge as the most fearsome and powerful fiendish demon in his era, that even immortals and fiends are fearful of him, and saints are at his beck and call.
Mastering the Supreme Demon Classic is the turning point in his life. He is able to unleash his immense and divine power from within, illuminating the entire universe!

A young man plagued by recurring nightmares finds himself visiting a blind fortune teller, who sends him to a world of martial arts that looks a lot like the wuxia stories he used to read.

In the sky of this world, a tome shines every now and then, revealing the hierarchy of mighty beings that seek power amid troubled times. Determined to unravel the mysteries of his involuntary journey and the secrets of the world he has ended up in, he endeavors to ascend the tome’s rankings, all while looking for a path back home.

Official Chinese blurb

Wandering the jianghu with a blade and wine, where beauties’ grace is filling one’s mind.

A youth, saber on his back and wine gourd at the waist, strides forth, yet the jianghu of his heart seems only more elusive;

With each flipped page of the Tome of Troubled Times, decades of nights soaked in rain pass over the jianghu.

As he suddenly turns to look back, he finds that the mortal world has shattered in his wake.

[Power System has beautiful Waifus as his spirits.]

[Read for the great plot and a perfect HAREM. There will be SMUT chapters only when required. The protagonist isn't Naive and treats his woman with care.]

[Read only if you want a great plot, sweet romance, a perfect harem, and good smut without any forced development.]

[Story would make sense as you progress I have avoided info dump and explained in a natural way to answer each question through the characters.]

*Ding!*

[Dual Cultivation System installed]

…

Yue Yan Gets kidnapped by the goddess on his sweet night with his girlfriend. She asks him to help her on a mission against the XieLong temple but he turns her down.

Later, some mysteries reveal their past and Yue Yan agrees to help her in order to meet his Bing'er again who has also been sent to the new world.

When he transmigrates into the body of Meng Long, he finds out he has a special Physique, the Supreme Yang body that stops his growth in Cultivation unless he Dual-Cultivates with a woman.

Yue Yan's new family had mistreated his predecessor Meng Long so he decides to leave the clan to embark on a new path with his beautiful concubine Xue Rou.

Join Yue Yan AKA Meng Long, in his Journey to reach the pinnacle of the world.

Lu Jiangxian died after staying up late one night. Yet, he finds his soul trapped in a fractured, bluish-gray bronze mirror. He falls into a boundless world of immortal cultivation and finds himself in the perilous landscape of Mount Dali. There, a small family from a small village by Meiche River picked the mirror up and is bestowed with the ancient teachings of the immortal ways, heralding the dawn of a splendid new era.