I think every team/project needs a goat who will argue that the strategy being chosen is wrongheaded and will lead to problems. And who will also enthusiastically work to succeed with that strategy after being outvoted or overruled, while keeping their objections in mind and working hard to avoid them as much as possible.

Some people who have the final say can't stand a goat, and take any negativity about their vision as a cue to start figuring out how to get rid of that negativity. They often code that as a bad culture fit.