I am the same way. I wonder if you've discovered your personality type? I'm INTJ so I'm great at big-picture vision and coming up with innovative ideas that might seem at first crazy or impossible to others.
But I'm definitely not good with the details. I'm bad with follow-through. However, I've discovered that if I align my principles with my projects, if I make sure my motivation for the projects I undertake comes from inside or is tied to my life mission, then I can stick with them longer than if I depend on short-term expressions of approval from others.
I have tons of old projects. At some point, I just declare defeat, consider it a learning opportunity and give myself permission to move on with a clean slate. The path to success is, after all, paved with failure. :)
I am an expert at making plans for my innovative ideas, too. I get hyped for these plans early on and want to implement immediately. But I've trained myself now to allow for a cooling-off period.
Last month, I developed a plan that I am certain would be of great utility to a certain community of people and net me anywhere from $10-$70K USD or more. But I shelved it because taking it up was going to threaten my ability to complete other projects I already had ongoing.
And failing to complete projects just kills me inside. It really hurts. I feel like I let everyone down and myself and failed to realize my potential.
Thanks for your comment!
Take the test: https://www.16personalities.com/free-personality-test