I know this feeling i've just put the wrong layer of paint on a building when it should have been something else first. As ozzyo says you are your own worst critic
I know what you mean its just a pain when you put so much time and effort into doing the job but when you look at it later and i think god that looks awful and get discouraged