First there’s the “Add spotlight tags” from Adam Rice. There’s no download, you make it yourself in Automator. Save it as a plugin in Finder, for right-click tagging. Next time you download a file, choose it in Finder, ctrl-click it and choose Automator>Add spotlight tags. Let’s say you’re working with a project, and the file downloaded is a picture that belongs to that project. So add some tags belonging to that project with this Automator action. Next time you use Spotlight to search for that projects tags, the file will show up, wherever you have put it on your drives.
Second: Complete Digital Photography has made lots of Photoshop Automator Actions. With these, you can automate lots of boring tasks in Photoshop CS and CS2.
Then head over to “Getting things done with Automator and Spotlight” and see how to use these in a brilliant way!