As one of my previous colleagues put it : "I'm a lazy developer. I will write a tool for anything that I must do manually more than once."
I think the hard part is to decide that it's better to spend several hours automating a 5 minutes manual task.
I'm often faced with repetitive tasks and I realize that it's wrong to do them, but it's not easy to say : "Ok, let's put my important work aside and automate this."
Another risk is that progress as measured to the size of the project is not linear, but asymptotically approaches '0'.
Real progress is still being made, but it is much less visible later in a project than in the beginning.
So those of us that are motivated by being able to measure their progress on a day-by-day basis have a hard time to stay motivated later on in a projects life-cycle.
I think the hard part is to decide that it's better to spend several hours automating a 5 minutes manual task.
I'm often faced with repetitive tasks and I realize that it's wrong to do them, but it's not easy to say : "Ok, let's put my important work aside and automate this."