The King's Avatar – For The Glory - Chapter 1 - The Summer We Were Fifteen

Jiang Pengji got something called the Court Intrigue Stream System.
System: “Your goal is to become the most prestigious woman in the kingdom (the Queen)!”
Jiang Pengji: “Okay, System. No problem!”
Years later, she met the target by becoming the most prestigious woman (the Empress).
Jiang Pengji: “Well done, no?”

- Description from Novelupdates

Abandoned since childhood, the male protagonist lived a quiet, unremarkable life, until the day he awakened a strange and powerful ability: he could hear the inner voices of women.With this gift, he could understand their true thoughts, hidden desires, and deepest fears.Suddenly, everything changed. From a social outcast to an irresistible enigma, he began to navigate a world of secrets and seduction. His main goal? To earn the approval of the cold and powerful president’s. But along the way, hearts began to fall, first the alluring president, then the charming teacher’s aunt, followed by the seductive supervisor’s sister…With each connection, his influence grew. But with every new woman drawn to him, so too did the dangers of jealousy, secrets, and emotional entanglements.Who will be the next one? ...

Revenge is the only thing she wants after knowing the truth.

Zhang Gong decides to learn light magic, a magic few show interest in and eventually becomes the legendary Grand Magister. While trying to end the continent’s east and west separation in order to unite all of the different races, he becomes every race’s Child of Light.