Recently it was released a great app for those who need subtitles: http://subtitlesapp.com
It requires you to drag the file onto it and it will download the correct subtitle. I can't open a file into it, so I believe some script is required.
Imagine the possibilities: Hazel checks for a new video file, "opens" it, gets the subtitle for you and then organizes the whole thing.
Ideas?