I'm trying Plex now since Front Row accessing a remote iTunes library is terrible (i.e. no album art, big monolithic TV show lists, etc.). However, when I went to set up my TV shows it found all but one TV show, and each show had 0 seasons and 0 episodes. So it seems a little rough around the edges... as one would expect from a 0.8.3 release.
But it definitely looks promising... much more so than Front Row which isn't even as good now as it was in the original release, IMO.
Don't want to derail this thread too much with Plex discussion, but organise your TV shows thus:
Show Name > Season x > "Show Name - S0xE0x.avi"
And it'll work just great
Use something like A Better Finder Rename if you have a lot of files to rename.