On OSX, there's a very handy program called Hazel that works as a "maid" (the creator's word, not mine) on your computer. I never like those kind of apps, but Hazel turned out to be incredibly powerful and useful. If you visit their forums, there are quite a few tutorials on various methods of managing media content (not all of it specific to the Hazel application), ranging from the legal stuff all the way to illegal. They have a few methods for automatically crawling TV database sites, understanding that there is a new episode available, searching a specific site (torrent or newsgroup index) for said episode, downloading it and moving it a specific folder, and using a TV database info to "intelligently" scrape the info and rename and sort the download. Basically ways to manually recreate what Sickbeard and Sabnzbd do. Very informative to read through it all if you use torrents/newsgroups (which I don't use, nor would anyone on this forum - I just like to know obscure boring nerd stuff like that). Anyway, try reading around that forum and you may find some interesting tips to help you on your quest. I ended up finding some useful links to HTPC automation websites, but I've since lost the links (that's why I'm not just giving them to you here).
And thanks to the people who mentioned Media Scout and Media Renamer. I'm on Win7 for my HTPC now, and all I had found was Renamer (which is supposedly quite respectable software, not a virus...perhaps their website or database gave google some indication that it had been hacked so they blacklisted it).