Balajesuri,
Certainly, there are individuals, groups, and organizations - like you - that will work hard to write good clean reusable scripts. And if you are primarily a Python shop then it makes that easier. Most of the time, when I tell people, "Stop Writing Scripts" it's to stop writing shell scripts. There is always a place for higher-level language scripting like Python.
To comment about workflow and workflow automation. I've spent a good part of my career designing and writing automation systems. And that's my primary focus today. I would recommend reading my blog post.
Workflows allow you to work at a higher abstraction layer. It let's a user focus on what they really need to accomplish by providing a great deal of the heavy lifting. It removes the need to understand things like: how can I run this on 10 computers, what if I need elevated privs, should I be logging for auditing purposes. Maybe a visual will help: