Unfortunately that's the nature of the creative process. When you're engaged in it time stops and you're totally absorbed in what you're doing. Once you're out of the zone it's easy to despise what you've created.
I'm not as pessimistic. I believe that by understanding the process it is possible to make allowances for this. It's just one of many challenges one must face in the pursuit of real excellence