A character who is out of the world perfect is someone no one can relate too. Even Superman had a weakness caused by Kryptonite.
What restrictions does your character have to overcome in your story/movie/TV show/song?
Elsa from the movie Frozen feels like she is restricted by her ice powers, however the real restrictions are her massive fears about her powers. As the movie progresses, Elsa learns to control her fear and master her ice powers.

