If you cannot automate tasks as part of your job, someone else who can will be more cost effective, or someone else will fully automate your job. Either way, I imagine being able to script some automation together will be an essential part of being able to gain work in the future, especially as so much of general work consists of repetitive tasks.
Sites like iftt and other introductions to scripting solutions, make this type of automation easy for the general population to get the building blocks of automation without the overheads of making a request to an IT specialist.
How many programmers work on mail merge or the many other office functions that have been solved many times over already? Yes, just as today, there will be some spreadsheets from hell and some vb messes, but the same productivity pressures will retain more of the capable ones than the mess generators.
Middle managers creating their own crap scripts can still have a huge impact on their productivity, and this is an area that some traditional IT departments have not supported very well other than to try to lock it down, albeit with some good reasons.