I have used it to clean up text files/logs, sort things, etc. I find it very useful to manipulate string data and arrays.
I am also considering using it to control my media server where I can search for movies or TV shows and launch via VLC (my media server is also my web server), but I am currently way too busy to even attempt this and currently will just continue with the .NET application I wrote ages ago.