Heroic spirits + no invincibility + Three Kingdoms + no angst (This is not a power fantasy. No one can stay invincible forever, and the protagonist has to grow too.)
In the year 206 of the Calamity Era, after the world's transformation, humanity can draw on faith and bloodlines to form contracts with gods and heroic spirits from history, gaining their protection.
High school student Cao Linyuan lives under someone else's roof, enduring cold looks and mistreatment from the Cao family. When the school's awakening ceremony begins, his younger cousin Cao Xuelin uses a potion to awaken Cai Wenji, an archer-class heroic spirit, earning the envy of everyone around her.
When Cao Linyuan's turn comes, the crystal suddenly erupts in a fierce, bloodthirsty red light that shoots into the sky and stuns the crowd. Everyone assumes his talent is peerless.
But the final announcement reveals that he has awakened only Cao Zhi, a literary-class heroic spirit in the top-tier third rank. The whole school mocks and jeers at him, even throwing things at him for sport.