The hosting provider is free to ignore counterclaims as well, and they frequently do. So I'm practice, the DMCA is much more effective than a cease and desist when it comes to major content hosts.
Things rarely get to an actual, legally compelled takedown because content hosts so often voluntarily take down content even when there's a valid counterclaim.