It does still increase the cost of automating usage of those sites, which puts an upper limit to how they can be abused. We probably won’t be able to go back to no Captcha without seeing a large increase of spam, spoofing, scalping, and scraping. They would have to give up offering most kinds of free trials and other consumer friendly practices if the bots can just make new accounts at 1000 per second.