In my experience it depends on the situation. In an actual project where you build something new it is always good to have someone skilled and pragmatic like that. However...
As always, it depends on context. Early on in my Career, I had issues saying no myself. I guess it's the normal Thing. Nobody has reason to challenge the "yes",...
If I want to ensure "quality" in a project, I implement a process to ensure this quality. This is not something that will happen automatically, magically or similar.
It depends on the industry and type application. My projects are data centric, mostly DWH. Once you get into integration across multiple systems, you need to put massive effort into...