In my humble opinion automation gives you more time to focus on other tasks but it also gives you a thorough understanding of the task you've automated and a better understanding of the scripting language you used for the automation. The introduction of an "enterprise scheduling package" in our operations area has certainly put a different perspective on "local" vs. "global" automation as well.

Just about everything I know about PowerShell I've learned from writing scripts to automate a task.