Struggling to think of a good example. Feels like a trope you see a lot in cozy fantasy where a powerful character has to adjust to a low stakes life. Maybe Curse of Chalion? It's not a perfect fit but explores aspects of this idea.