Oh yes, definitely. Having rough edges, or a bad side humanizes a character, which has been proven to lead to more relatable and likeable characters. It’s the driving force behind the whole antihero thing.
The good examples are definitely out there, but all of them are niche and the problem is likely that big productions are afraid of taking a risk by not trying to please everyone. Which also explains why recent large productions all have this shitty writing that feels artificial. Doesn’t matter if it’s feminism, LGBTQ+ themes, representation of ethnic minorities or just the cookie cutter cis white protagonist. They manage to enshittify everything by playing it safe.