Chercher trop loin ou trop proche

Between looking too far for qualities or too close for faults, what is the happy medium? Faults that can be overlooked, you say? Well, I am often willing to overlook quite a bit, for the sake of a feeling. But what if that feeling still isn't enough? I'm so confused...