I've used powershell to monitor adobe campaign services and to automate troubleshooting tasks (stopping, restarting services), also to trigger workflows and transactional emails from windows server to the adobe campaign API.
I don't think you will ever need powershell scripting skills with adobe campaign unless you manage the actual servers where the services are installed and that's considering the operating system is Windows.