Fear of success vs fear of failure.
There is definitely a fear of success, as their is a fear of failure.
The main difference is the expectation. Someone who has a fear of failure, expects failure, and deep down believes, "I can't do it, and don't want the embarrassment and shame associated with failure." So, they don't try, because they don't want to fail again and again, which proves what they've been told, "You'll never amount to anything." That voice becomes their own voice,"If I do that, it will just rot. Nothing I ever do is any good."
Fear of success is different in that you know you can do it. You expect that you can write a book, and that you can build a business. The fears aren't about "the success", but the price that goes with success.
For instance, if a father has an athletic son, who knows he could get a college scholarship, but like "One Tree Hill", you have an overbearing dad who will ride him, the storyline shows how the "Talented Kid" Quit, not because he couldn't play basketball, but because as long as he has played, he's had to endure the scorn of his father riding him and pushing him.
It can be much more complicated than that. Some people have a hole inside. They may feel embarrassed being in the limelight, even to the point of social anxiety. Deep inside, it could be a fear, knowing they could cut another record, or score more touchdowns, but they don't want to deal with the demands of the industry, the show and tell, the critics.
Some people love the art, but don't love what comes with success. And so, they may actually try to fail on a subconscious level.
Where does that come from? Generally it is learned somewhere in life. And perhaps it is the fear of emptiness, that when you get there, it will not be what you expected, like Ecclesiastes, where they accomplish great things only to find out that it was empty.
In my case, I'm not sure I fully understand it, but someone said something to me once, "You are this person who is larger than life, but you always seem like you are hiding." It wasn't an insult, but rather to say that he saw something great in me, but also this desire to retreat into the shadows, and I realized there might be something to it.
I can't say that I'd really want to be famous. When I was a young man, I was a scholarship athlete, and I was a fan favorite. "Imagine thousands chanting your name." Some love that, but I always felt uncomfortable with that. I felt uncomfortable with so many people in town knowing me by name, and worse yet, I was terrible with names, so I'd forget other people's names, and felt embarrassed, like they would think I didn't care about them, because I couldn't remember their names, so I'd developed these coping skills to try to address them without saying their name.
I've been in positions of honor before, where people carry your bags, and treat you like an important person. I like to carry my own bags, and felt quite uncomfortable. In a weird way, I'm a push-me, pull-you going in two directions. Why? I still don't know.