I've always felt that if you have to ask why then you'll never "get" it and chances are this game is just not for you. There's still always a possibility you may embrace it. People that love SotC found out about it on their own and didn't ask anyone if they'd love it or not. They were just seeking something out that they felt was unlike anything they have seen or played before. They NEEDED to feel something "different" and "unique."
Playing SotC to me is comparable to a spiritual awakening. For me, everything about it is very deep and spiritual. The feeling I get from it is almost biblical in a sense due to the fact it is focused on one man's journey to resurrect a lost love (or friend, etc?)
I've noticed many players who are deeply fascinated by this game seek questions about life. They are looking for wisdom. SOmehow, this game evokes these kind of feelings to me. The first time I have played it I couldn't help but find myself in deep contemplation over what happened in the end. It was so moving to me I couldn't accept it and (without spoiling anything for anyone) I've made the ending last a hell of a lot longer than it should have due to this element. It's a fascinating, emotional experience reserved for the few who enjoy the finer things in life.
If you're a person who is impatient and wants to rush things and get things over with and doesn't have time to stop by and smell the flowers or observe their surroundings while going out for a walk, this game ain't for you. That's the best way I can put it.
Shadow of the Colossus is special. I think I can speak for everyone who has played it how lucky we are that a game like this even exists. That there is actually an audience for this kind of storytelling and gameplay.