To me, content filtering seems like a nice bullet point in the "we don't condone copyright infringement" department. It reduces complaints that result in lawsuits, and doesn't really hurt anyone. If anything, it discourages reuse of RIAA/MPAA content and encourages the creation of new free-as-in-speech content, and that's definitely a good thing. Your cat video doesn't need a top-40 soundtrack to be enjoyable!
(It's similar to how Microsoft's attempt to lock up the web with proprietary technology resulted in Free Software web browsers becoming usable. Remember the days of "This site only works in IE"? Now pretty much every site works in pretty much any browser. Epic win.)