I think the answers or recommendations being submitted here are addressing the issue nicely. Interesting topic.

It is a rare individual who has the talent or is surrounded by musicians with the talent to take a song as conceived in one's mind and get it into a recorded medium exactly like it was originally in their head. Not impossible, but not very likely IMHO.

I do think the more you write and translate the ideas into the real world the better you become at both.

As far as being a prolific writer.... absolutely. I heard Jeff Steele speak about his writing. He had 24 #1 country hits at that time. His goal is to write something new every single day. Assume a 5 day work week writing songs and he gets about 250 songs a year. if 10% are worthy and get recorded, that's 25 cuts, and he said he averaged about 1 in 100 actually getting up the charts to the top as singles. Yes, you need to write a bunch of rocks to find the gems in the lot. Simply write..... don't be looking to intentionally write a #1 song, just write from the heart, follow the twists and turns on the way and things will either work out or they won't.....either way... did you learn something in the process and have fun? If yes... mission accomplished.

You can find my music at:
www.herbhartley.com
Add nothing that adds nothing to the music.
You can make excuses or you can make progress but not both.

The magic you are looking for is in the work you are avoiding.