I use Automator for all sorts of useful things. For example, let's say I have dozens of pictures from a vacation in Hawaii, with random numerical names, and I want to transfer them to my Mac, and rename them instantly. I have setup an automator action to monitor a specific folder. Any pictures I put in that folder, an "action" will pop up, with the option to rename all files in there in consecutive order. Example, I would name them "Hawaii 2011_1 through xxx. Then, within that same workflow, a new album will immediately open in iPhoto, also allowing me to name that album. Very useful when you have tons of pics!
Another one I have - very often, I am browsing the web on my ipad, but I want to see that link instantly on my desktop mac. I have an action, that I can email that link to a specific Dropbox folder that automator monitors, and will open the link in my default browser. It saves me the step of going to my desktop email, opening it, then clicking on the link. This works, even if I am in a remote location, far from home.
I also use a similar folder action, whereby I can email a file to another dropbox folder, and it will immediately print whatever arrives in that folder. I just used this action, from here to print instructions at my home for our House-sitter.
I have quite a few more, but they are at home, and I am on vacation many miles away.