I see the potential for Powershell, but I'll admit I'm in Steve's camp. I have a lot of ad-hoc queries and processes that I run much more often than I run things that need to be repeated or run across a bunch of servers. For me, Powershell as a daily use doesn't make as much sense. However, I've used it to easily encrypt/decrypt data, move files around, FTP, launch other processes, and so on. Those are definitely the exceptions for me. It's still in my list of tools to use, but much more sparingly than I use T-SQL in SSMS because of the nature of my work.