You've created hundreds of files using one naming convention only to discover that a different convention is required. Don't sweat it. With Automator you can batch rename them with ease.
Care to check in on the area in front of your computer while you're away from home? With Automator and a properly configured Mac, you can.
Ready to make DVDs for the holidays? A little know-how and some help from Automator makes it easier to do with iMovie 10.
There's no reason to let a kiosk presentation run when there's no one there to watch it. With Automator you can trigger and shut down these presentations at appropriate times.