Oh man I know this feel. I have been programming for startups for years and I have always had lots of ideas but never the mental commitment to finish anything.

Oh man I know this feel. I have been programming for startups for years and I have always had lots of ideas but never the mental commitment to finish anything. I'm proud to say that very recently I did manage to complete a side project that I intend to launch in a week or so. It is a social site based on an idea I got from watching Japanese dramas. What helped in my case was that my idea was really simple to build. I too have zero frontend / web design ability, so I just paid a guy from Craigslist to fix it up. Being able to bootstrap a finished product with a relatively small amount of time / money helps you get in that "closer" mentality instead of just playing around and never finishing. I'd also suggest not worrying about making money at first. Just try to make a cool product or service. Money is a stressful and distracting motivator I find. Once you have something of value to offer and get some feedback from potential users, then you think more about pricing and marketing. So in short, start small, don't be afraid to outsource and trade money for time, and don't worry about making a profit right away. That worked for me at least.