To say someone is a vision is to pay them a great compliment. If you say that they look a sight it is a grave insult.