How do I deal with high expectations?

Who is paying for your college expenses? That is key to how you handle the comments. The person who pays gets to make the rules.

I would lessen the talk about wanting to be near ski resort when you speak to relatives. Find schools that fit you well, including ones near ski resorts, but focus on talking about non-ski reasons why you want to attend.

This one has the major I want, that one has a great reputation with major employers in XYZ field, I visited that Ivy school and did not find the Math Dept had professors that were engaging with their students. The food was awful at Fancy College, the freshman dorms are old and smelly, you get the idea.

I think you are fine to make ski conditions one of the factors in your college search, just don’t lead with it when you interact with relatives.