Sight for sore eyes

What does a "sight for sore eyes" mean excatly? I've had people tell me it is a negative saying, but I always thought it was positive, implying something what somehow soothing. Anyone know?