I think people disagree and argue about this so much because each preference is true in that developer's context and environment. Everyone who voices a general opinion should indicate what kind of development they do.
How could it possibly be that unit tests are "good" or "bad" in general, for all software development?
How could it possibly be that unit tests are "good" or "bad" in general, for all software development?