What I use is XBMC with simple SMB file sharing over network shares as needed.

I keep some stuff on the HTPC itself, and other stuff is streamed over the network. Works great for my rather simple needs.