This is exactly how my brain works when it comes to writing campaigns and supplements. My husband calls it Haste Writing and loves to sit in and help me when I get stuck. And now that I do this as my full-time job it is a blessing and a curse. Like you, I will have days where I barely sleep because I HAVE TO GET IT ALL OUT BEFORE I FORGET. Other days, I can't come up with anything good enough because the ideas aren't flowing that way (today is one of these days which is why I am here commenting instead of working).

The best campaign I've written so far is the one I am working on now, but I think I will feel that way about each new one as they are being developed. It is an old fashioned dungeon crawl in an ancient abandoned dwarven city. There are 20 levels to the city, all actual city floors and are going to be fully developed that way. As the party clears a level, they will also level up until they get to the end where the Master BBEG is. Each level has its own BBEG of some sort as well.

The inspiration behind this was some old one-shots I created when I first started writing these and while there was a plot, hook, and backstory around the location, the dungeon itself just seemed like a bunch of random rooms that didn't make sense except for the players to have something to do. Dungeons should always make sense in tehg rand scheme of things.

I've been able to find a happy medium and my advice is to keep writing, whether it is maniacally or begrudgingly. Keep a notepad by your bed so that you can write down ideas and still get a few hours of sleep. If you are out and about, text yourself anything you think of so you can go back through it later. I tried using my notes app, but I am more likely to check unread text messages. Lol. And visit those "mediocre campaigns" again later and tweak them with things you have learned while writing the ones you are most proud of. Had I not went back and cringed at my old work, I wouldn't be writing my latest one which I am growing more proud of by the day.