"Perfect" Characters and The Galatea Trap

Is the perfect character preventing your story from being believable? The Galatea Trap (aka Mary Sue) is a real problem in fiction and film. Characters' flaws are what make them compelling, so when can you use the Galatea Trap to your advantage?