Yeah, I've been trying to make an HTPC centered around my video files for a couple of years, now. I messed with XBMC, Windows Media Center, and MediaPortal, and they all have their ups and downs. For video file management, MediaPortal is topps, because the video player interface lets you tap all of the functionality of matroska files with a remote.
Support for non-anime video files in an HTPC setting has been around for a few years now. As long as you don't have multiple subtitle or audio streams, it worked rather well at guessing what shows you had, so you didnt have to enter stuff into an sql database. Obviously, from a user standpoint, you just want it to work without any tech stuff, and these programs worked, except for anime.
As for anime, my problem was always getting the files recognized as what they should be. While thetvdb.com is great for non-anime shows, it's horrible for anime, since the name of each show could be listed in either kanji or an English translation, and you kind of have to guess. Also, reading the filename of most dvd-rip and fansub files is usually buggy, because most regex lines (used for reading the filename and 'guessing' what episode something is) will try and read the crc label in the file as a season or episode. Also, it will usually guess what show the episodes belong to based on the name of the folder they're in, and that requires guesswork, and checking on thetvdb, etc. So, oftentimes, I found myself renaming every episode, and then relocating them in utorrent so I could still seed them.
Well, MyAnime solves these problems in two ways: First, the filename and folder name don't matter, since it recognizes files with hashes. Second, it uses AniDB for show info, as opposed to thetvdb.com, which provides more relevant information. However, it will download fanart from thetvdb, so your front-end will look cool.
I know lots of people would prefer a standalone version, since they aren't trying to set up HTPCs. But, they are really cool, and these days, you don't even need to do anything crazy. But really, if you want to use any media center, get a remote!! I tried with the mouse and keyboard, and it's barely operable that way. With a remote, you just plug it in and use it.
I recommend this remote:
http://www.newegg.com/Product/Product.aspx?Item=N82E16880121002So, AceHigh, or anyone who feels uneasy trying this setup, I'd be happy to help you through the process. I can help you setup anything from emulators to movies to anime to tv shows.
But, it's really gotten very simple since I started it a couple of years ago, lucky for you guys!
Just post here for questions, or find me on IRC. I'm usually in #animehq, #bakabt, #myanime, or #chihiro.