Comment More details required? (Score 2) 361
Well, I guess the key starting point is what operating system are you running on?
But for my rather extensive movie and tv collection, on windows I've found Mediaportal: http://www.team-mediaportal.com to be fantastic with its range of plugins to cope very well with TV and movies. Specifically the MP-TVSeries plugin for TV, which interfaces with the TVDB and gets all the information you suggest you want about your shows, including actor information, fanart, banners, posters, thumbnails, and the list continues. You can also sync all these details with an online tracking website such as the relatively new trakt.tv so you and your buddies can see what you recently watched (all done automatically once you have an account at the website and configure the plugin).
There is an equivalent for movies called movingpictures which does pretty much the same thing, and you can set up your own categories for sorting too.
Mediaportal is a spin-off from XBMC, but is also opensource, and free, but only runs on windows (and makes a very good HTPC software on the whole). So if you're not running windows, maybe try XBMC instead.
That is just my personal experience, your mileage may vary.