DVD Profiler and Collectorz.com Movie Collector do this and more they also store "Easter Egg" info for DVDs and the "Special Features"!
unfortunately both programs suck in regard of Cover and Actor management.
GUI wise I like this one (Ant) best, although I miss features like "Price Finder" (DVD Profiler), HTML View (DVD Profiler, extr. Movie Manager, Collectorz.Com) and Actor Database (extreme MM)
I also like the way you can add DVDs in DVD Profiler, by just entering the UPC Nr. of the DVD. This guerantees that the EXACT info is added and you NEVER have to manually chose between any titles found via "open script" solutions.
All in all, Ant Movie Collector could be the best, right now there's no such thing out there because all have one or more "major" flaws.
For audio CDs there's one perfect piece of software: Music Label 2003
http://www.codeaero.com/musiclabel/
Pity it's for audio cds only.