I find it's context dependent. Sometimes everyone is working hard and doing their best and someone's being a toxic jerk. Sometimes things are going badly wrong and you
need someone to actually stand up and say "Hey, how come these requirements keep changing we've wasted months doing something that was totally useless" or "Hey, how come our AWS bill is $100,000, and hang on a second, why isn't anyone monitoring our AWS bill?" or "Hey, the core premise of this project turns out not to be true, maybe we should really re-evalaute rather than ploughing on".
Sometimes requirements are unclear and you just have to learn as you go. Sometimes the AWS bill is the last of your porblems. Sometimes you find out something you had assumed at the outset is wrong, but you still believe in the project. It's context dependent.
Also, it's often more difficult to be the person asking the hard questions than the person who just goes along with things.