Unit tests are of some value Only when you find yourself actually testing something manually a lot and would love to automate that - in other situations it's mostly another costly vanity coding.
Exception #1: Big enterprise software, where codebase maintenance and stability is more important than change (creative work does that a lot)
Exception #2: Well staffed MATURE game projects going for stable release