I'd also like to see it come with relevant costs. Much in the same way genius and madness often go hand in hand. Not full on oracle's curse, more like how some beautiful people struggle being taken seriously or respected for their minds, or how some neurodivergent people just get difficult subjects while struggling with aspects of ordinary life.
But yeah generally I'm in full agreement with you. Show me the half orc who only got a chance in their hometown because they're a sorcerer and that resulted in complicated emotions. Show me the noble whose family paid good money for their child to be a sorcerer and now they're off trying to prove themselves. Show me a society in which a sorcerer child is considered an unimaginable blessing even though that bloodline may leave their sibling a hated tiefling and then use it to show a golden child/scapegoat sibling dynamic enforced not necessarily by the parents, but by the whole community.
The Locked Tomb did both. Necromancers are a blessing and privileged. There are roles in society only they're allowed to fill. But they're also chronically ill. They're frail and sickly and look and feel like they're dying. That actually would give credence to if they were to not like being like that.