I've found the sweet spot for tests are

- complex code that will change with definable inputs/outputs that won't

- large projects

I've found they're not nearly as helpful in

- small projects

- UI intensive code

- code where the requirements are ill defined and change often