I've never heard a small content creator say anything good about the DMCA; all I've heard is big content abusing the system to claim the work of small creators.

Also, the entire premise of your DMCA example for small creators is false and trivializes the difficulty of even finding violations. "Google searches are free"? As if I can spend 5 minutes google "who copied my stuff"?