Automator can do much then most people give it credit for. Here are the top five Automator actions:

Dashboard Disabler 1.1-
A two-part program that turns of your dashboard reclaiming memory that you use running widgets in dashboard. If you run the second part your dashboard will be as good as new ready to use in a flash!!!
Maintenance 3.8-
A simple Automator Action fused with AppleScript aimed at keeping your Mac running healthy. -
Quick ZipNFO 1.2-
With this small tool, you can quickly see – without unpacking ZIP – what is inside of archive file. Information about ZIP file contains also many other detailed stuff! Use it after downloading ZIPs from unknown and untrusted locations!!! Have fun
Flickr upload automator action 1.1-
As easy to use as Automator itself this action uploads your favourite images and photos to Flickr by simply adding it to the workflow.
Download URLs as PDFs 0.3.1-
This action for Apple’s Automator allows the user to archive a web page as a PDF document in a given workflow.

I personally have just started fully utilizing the program and it’s crazy what it can really do. It’s really impressive and very powerful.