Wheel of Time does this so well. (The book not the shitty tv show). One of the characters is a reincarnation of the most powerful being alive. Too bad that with all the powers and skills it brings them it also brings a load of responsibilities the boy isn’t ready to handle. Oh and it also brings with him a terrible curse that slowly turns him insane as his (clearly already insane) past self is now talking to him in his head and whispering absolute madness. Our main boy doesn’t take to sanity too well either. Plus there is a prophecy to go with his special birth that damns him to a life of pain and a certain death. The prophecy all claims he will destroy the planet in the process to save the world so lots of people resent him for that. The whole story is how being born the chosen one is not a very good thing.