I agree that additional more complex examples might be interesting, though.
It seems that there's always going to be a sliding scale, depending on how complex the task is. Some software will provide fairly straight-forward mechanisms for performing some tasks (such as find and replace) and some things will end up being potentially more difficult (maybe, say, find and replace with a regex).
In an office setting I think there's a good case here for having someone that's IT/programming/automation savvy working with people to improve their day to day process.
I've actually done that before at my job, in an informal capacity. I occasionally go sit with the folks on the operations side of the business so I can learn more about what they do, and more effectively build things for them, and often times I end up telling them a lot of tricks in excel, or word, or whatever else, that make there job easier. In a few cases I've managed to create quick tools for them that substantially reduce their workload with minimal effort on my part. In a strict cost-benefit analysis, it's probably not worth my time, but it pays a lot in inter-department relations. Of course, my working environment allows for that, but I mostly mean it as an anecdotal example of what I'm talking about. ymmv.