I really had to think about this because I think it's changed over time. The trait that used to get me most in trouble was my tendency towards socially-prescribed perfectionism. I wanted to be seen as good and I let it override my authenticity. It held me back from saying what I really felt and doing what I really wanted to do, and made me extremely codependent. What usually ended up happening was me being insincere and being caught between opposing forces (such as what someone else wanted or believed and what I wanted or believed). Someone always got hurt as a result, including myself. It wasn't admirable or functional at all!
But then I had a mental breakdown and realised how dysfunctional that was. And now I am way more honest and that gets me in trouble now. I still have some perfectionistic tendencies which means even when I'm being honest, I'm hyper-aware of how it will be perceived if my honesty doesn't fit the status quo or, as you say, isn't what people want to hear. And I think it has made me a lot less popular. But I like myself so much more now.
So yeah, it used to be perfectionism, Now its honesty.