Need goals AND dreams to keep going.
Fitness goals are new to me, I just want to look better at 50 than I was at 40, and I'm on my way to it. But barely find it motivating enough to work as seriously as I could.
My dream (unrealistic), is to become again able to do track and fields, if aging lower enough my explosive power so that I become again able to do intense stuff without tearing my muscles.
The unrealistic dream motivate me a lot more than the reasonable one, it sustain me when the narcissic motivation feel so vain I could quit.
When I was a kid (10yo), I dreamed at nigh to get a medal in county level track competitions. I was so ungifted physically (slow, weak and uncoordinated), that when I finally succeeded 4 years later, all my sport buddies and coaches felt I did reach my max, and that it was awsome.
For me, I still felt humiliated to be so weak, and dreamed sweet revange beating all those physically gifted jocks so out of my league.
The dream to beat the popular champions sustained me and my investment in training, and I ended up reaching international level, a miracle the guys who knew me as a teenager still can't beleive.
A goal is just an intermediate reasonable target, it's dreams which creates motivation.