Definitely
MediaPortal with the
StreamedMP skin.
Dending how you get your movies onto the HTPC,
Moving Pictures is great if the movies are ripped to the HDD/Network drive. Gives you some nice cover/fan art and movie description.
And if you download TV shows, grab
TVSeries. Works similar to Moving Pictures but is for TV shows.