The Sword God from Beyond the Realms

Urban life + cultivation + invincibility + mythology + the end of the ancient cultivation era + spiritual qi revival + no harem

This isn't really a power fantasy in the true sense. There are no martial artists, no revenge for being wronged, and it's quite different from other power fantasies. It's more about exploring hidden treasures, seeking inheritances, and protecting one's people.

Ji Ziheng was once the Sword God of the Ziwei Star. After failing to survive the divine tribulation, his soul transmigrated to Blue Star. He thought he was an invincible king, but later discovered that Blue Star was no ordinary place: it was a sacred cultivation ground in ancient times. On his journey to godhood, he leads the divine and human clans in a fight against the demon and monster clans.