Why goals won’t bring you success and what will

I have been a goal setter ever since my mid-twenties.
And when I look back, I notice that I achieved some of the things I set out to do and failed at some too.
I used to be hard on myself over my perceived failures, thinking I was not somehow good enough. Yet I now see things differently and in a way that gets better results and without self-defeating critical self-talk.