The man who all women must settle for when they discover that there is no Prince Charming. Often does have good attributes, but is far from perfect.
Term can be replaced with "douche in shining armor."
Woman 1: I can't believe it's finally your wedding day. The dress is perfect and so is your new husband!!
Bride(sarcastically): Yeah, he's a real douche charming...