MythTV has been serving me wonderfully for years. It's an incredible system and is still my primary media solution to this day. Unfortunately, the tools provided for managing video metadata have fallen a little behind. I recently switch away from Boxee and gave XBMC a try. What a fantastic front end and the media management tools are perfect.
My wife and I watch Star Trek Voyager each night to fall asleep (I hear you snickering). A minor frustration is that I have to fast forward through the intro credits, and I also have to exit out at the end, select the next episode and then get through those intro credits in a few minutes. It's a really minor annoyance but one I am proud to say I have overcome with the build-in EDL (edit decision lists) that are supported by XBMC.