Mike_Jones after many a failed band I can assure you the toughest bit about finishing a tune is not over evaluating it.
After a few listens all your confidence drains from you. The self critic takes over.
I always been sure that the real skill is part perseverance and part not caring too much. Finish it, go write another if its wank.
Every now and again, if you adopt that approach, you are going to get a Frog Chorus. But you also get Maybe I'm Amazed.
So its swings and roundabouts.