No choice. I've learn VBA and Powershell only because they are the only things I have access to at work that allows the computer to work for me rather than the other way round. In the past I've run autohotkey portably to automate corporate systems that seem designed to maximize the number of clicks to get anything done, and for "glueing" systems that don't speak together. I'll learn anything that makes my life easier.
I agree, it's massively undervalued. Sure the syntax isn't for everyone but out of the box it has much of the stuff in it that on Linux I'd be reaching for awk, jq, etc. Not to mention being able to pull in stuff from .net and other windows things. I can't fault it.
