I know what you mean. It's such a bummer.
But I remember one guy saying how his art process started out with him thinking it was going to be awesome, then terrible, then OK, and at the end he feels content with how it turned out. I think that's how most pieces go, lol.