There are too many shiny objects and it is killing me

Simply put: You're shopping, not creating. I went through a phase like this, too. It also had some relation to being stressed, or not socializing enough, in my case.

The healthy thing you want to be doing is practicing. Ground the big idea within the question, "what part of this can I start implementing now?" It doesn't matter how tiny or trivial that part is, as long as it has a clear link to the big project - the more direct, the better. Allocate time to implement that, instead of shopping for best practices. Allow your implementation to be a little bit cruder than you think it should be.

If you're doing anything worthwhile, you'll soon land in a zone where tools and tutorials don't really help you anymore. There's just the project you have, and your will to work on it. You can still fall back into the shopping cycle at this phase by rewriting things with a different tool or technique, but that's where you should reassert the part where it's "a little bit crude." Focus on concrete, measurable metrics, and you will get away from the spell of "best practice."

Maybe you've overdone it a bit and lost track of what originally got you into all of this. If you scatter yourself and chase every shiny thing your core motivation gets kind of burnt out but you don't notice it for a while because all those more superficial obsessive drives keep going once the main engine has run out of gas. Perhaps take it easier for a while until you feel a deep urge to do a particular project.

I got like this after many years of study. So much to learn, I turned everywhere at once and learned many things. After several years I ended up feeling lost - this forest was infinitely deep and infinitely broad, and I didn't know where in it I wanted to go. Though I still had personal identifications that said "this is what you do, you're good at this" and the superficial curiosity to keep learning new things, the deep sense of direction was gone.

The only thing I've found that lets it regrow is to give yourself a break, do something different with your life for a bit. When a deep motivation grows, the shiny things won't distract you from it. When they do distract you that's a sign that your deeper drive has withered somewhat. You can't force it to regrow; you have to wait for it to do that on its own.

Thanks for this comparison. I went through this very same thing, and spent a lot of time and ammunition firing at the wrong solutions before I landed on this very same thinking. Best practices are fine, but it's way more important to get some code written for that feature. Forging ahead without tutorials and Stack Overflow (using only what you know as a software developer in general) is going to make you a better, more productive developer a lot faster than anything else. The shopping metaphor is excellent.

I often don't get that far. I just come up with all the potential problems with my idea; usually related to monetization or existing competition and then I bin the idea.

Stop caring. Make something messy and shitty. Tell yourself you are going to make something messy and shitty; gleefully ignore any "best practices" that make it a pain in the ass to just slap something together.

Don't worry about a name or a domain or a hosting or whatever. Just slap it together in the stupidest way you can. You wanna make a game? Build the gameplay with colored blocks moving around in some crappy toy game-making app. You wanna make a web app? Shit something out in PHP.

If your utterly shitty implementation of the idea feels like something worth pushing further, then you can start investing in Doing It Right.

This goes for any field, by the way. Obsessing too much about a painting? Grab a crayon or a highlighter or whatever and some cheap paper and make a few messes until you have something that actually works, even in its shittiness of execution. Making music? Just plop down a few chord progressions or some little doodles of melody or rhythm, until something has that spark. Writing a story? Scribble down the barest outline of the plot and ask yourself how many cliches you can count, sit down with a bottle of wine and a notebook and a list of interview questions to pick from to ask that character who's sitting in the back of your head and won't go away.

Whatever you want to make, make the crappiest version of it you can, and then start refining it.

And if all of your ideas are too good to sully with this, don't sit there. Put them in a notebook, and come up with some throwaway ideas that you're perfectly fine with doing shitty versions of; this will hone your skills, and eventually you can look at that one shining, amazing idea that still seems like a good idea twenty years later and decide that it's time to have a go at it.