For movies I can recommend:
http://www.mymovies.dk/
it works nice with windows media center (which is actually quite nice), you can include digital and physical media.
For music:
If you have your mp3s or flacs tagged with integrated album graphics and folder graphics, including lyrics is a bit overkill in my opinion, wmc again works well, as do most media players.
Pictures:
Lightroom? Adobe Bridge? I dont know.
Books:
Calibre does best.