The key, to me, is determining what needs to be tested. That doesn't change with larger code bases. Note that I didn't say that tests were pointless or that you shouldn't write tests. That's incredibly shortsighted.
Originally I was going to title this "Tests are overrated" but that both seemed like linkbait and distorts my actual opinion.
I've been on projects where they tested to make sure that certain values were unique in the database and I couldn't help but think they: didn't understand the framework; didn't understand what tests are meant to do; didn't understand database key constraints; or all of the above.
Tests have their place. But they are a means, not an end. And I see a lot of people confusing them for the end.
But, again, I don't dislike tests. I just dislike what I perceive to be a current overemphasis.