I've got a few but not sure anyone would be interested in having themselves. They're all very simple. I think Automator looks tougher than it is. Once you understand what the actions all do and the structure required in a workflow, it's suprisingly easy.
I use one that downloads the iTMS music videos, two that find and copy images/music from iPhoto/iTunes to the desktop without having to open the respective app, one that resizes screenshots, convert to jpgs and renames, one that allows Image Capture to rename files from my CF card sequentially before importing them to iPhoto, one that finds birthdays in iCal and sends birthday greetings automatically.