Yea true, if they completely fawless in stories it can get annoying. Feels more realistic with the 'perfectly seeming prince charming' having a flaws as you get to know them more.
I like both 'prince charming' and 'redeemable badboys' in other media. However similar to you, I dont like the "badboy types" that just abusive, creepy and a total jerk expecially to the significant other who just accepts it, that just feels abuse victim-ey and a story like that may lack any narrative growth, unless maybe they were side characters and the protag was trying to convince the 'abused individual' to see further than the 'abusive lover'.
Usually when writing enjoy making characters that may have a bit of both charming and badboy, or maybe slight leaning to to one of the sides " in their 1st impression". I prefer thinking they have layers like real people eg. many people in your life would have the sweet caring side in their usual setting but may also have a rebellious 'badboy' side when needing to get a task done or a point across. I imagined Evan from Sickboy we build familiarity of him as the caring brother to his little brother Owen 1st and overtime you see a buildup of his 'mischevious', recklessness and preferance to play by his own rules (stuff attributed to badboys).