Unless you're automating business processes as a contractor brought in to be a hatchet man, the general momentum of a company and thr business politics at play are going to reduce what's possible significantly.
The big wigs might want to see cost savings, but they want to see big numbers fast. They don't want long term payoff from improved efficiency that also causes all the people under them to bitch and moan about how much they don't like change.
I say this as someone who automates shit and gets different systems to speak to each other in order to improve quality and efficiency as my job: the only way we're going to see major changes in this is if new lean companies somehow out-compete the existing monoliths by using automation. Otherwise we're just looking at incremental changes over time, not some unemployment event horizon where all goes to shit suddenly.