I know the stories I publish are imperfect, but the stories I read are imperfect, too. Readers do give authors some latitude and I expect to be given that courtesy by my readers. I don't usually sweat making my novels utterly perfect. The story simply has got to work. Once I think it does work and I have a beginning, a middle, and an end, I'm done except for some tweaks.
When a story isn't going the right way for me I have learned to listen to my muse, because it is trying to tell me that my idea for the story or a particular character is wrong. When I don't listen, that's when writer's block can occur. I can't force my characters to do what I want; I'm only the sculptor revealing what is there already. (Well, not that arty, but you get the idea.)
However, there is more than one kind of writer's block and I suffered through the disastrous kind for many years. Soon I am going to decide if I will ever attempt to rewrite a story I rewrote completely but abandoned. It doesn't feel good to have abandoned a story I put so much into but, as we have discussed previously, some themes are simply passe and I can't imagine anyone wanting to read that particular plot today. So I'd have to completely rewrite it again. What's the point? To say I finished it? Maybe, but is that a good use of my time?