it’s not generally law enforcement enforcing it, it’s the copyright holders threatening civil action against things like internet service providers, who in turn will cut off your internet or some such. they have a lot of money, so they get law enforcement to do their bidding when they want, but the majority of DMCA action is civil action. this is, my very uneducated opinion looking from the outside