Also in the end there are probably different types of managers. Some expect honesty, some don't. Some are optimistic about humankind, some not and others in-between. All of those types can provide value though.
I think it also shows the importance of soft skills. There's been a couple times where I've had disagreements with my team leadership, or senior management. I could make statements about why I thought I had made reasonable decisions. But honestly I would admit that those situations wouldn't have been as serious if I had communicated differently. So at the very least I've learned where overcommunication might be important.