You use it to do repetitive tasks. For example I used to use it to rename batches of files in incremental fashion before I found Name Mangler. I've also used it to fix up track names in iTunes and to sync files on my webspace via Transmit's Automator plugins.
It has a lot of shortcomings, but it's fairly easy to use and generally gets the job done. It can definitely save you a lot of time.