DMCA fails on all fronts.
The era after it's passing was one of the most prolific eras of media piracy, and also one of banner profits for the media players that pushed for it.
Every premise it was built on was flawed or an outright lie. What got people off the pirate feeds was cheap streaming content from the likes of Netflix, Pandora, and Spotify. Google got it's star acquisition not only exempted from enforcement but in the process got itself a sweetheart deal paying pennies on the dollar of what the other music and media companies could negotiate. Essentially permanent most favored nation status.
YouTube was founded on pirate content. During the trial they showed that their own employees were responsible for uploading massive amounts of material that formed the core of high quality content that allowed the platforms explosive growth. That lawsuit only went away because nobody in the valley wanted to be on the wrong side of Add Daddy. So Google fed the content industry most of it's competition, and the studios signed a Faustian pact with the devil to allow Google to continue to profit off mass piracy.
The DMCA thus failed at it's legitimate purpose, and what remained was for it to be used over and over to attack security researchers, open source developers, and competitors. To harass and intimidate journalists and musicians with fake takedown notices. (or real takedown notices based on bogus claims).
The DMCA and the patriot act were both disasters, and instead of repealing them, we are still living in their shadows decades later. These terrible laws help normalize an era of predatory laws protecting the narrow interest of the largest players, and normalized a bold new era of looking the other way while leaving things utterly and obviously broken.
How'd that work out for us again?