This is like Mt. Fuji in Japan--beautiful from far away, but ugly, dirty, cold, and generally uninhabitable once you get close to it.
Also known as the Mt. Fuji Effect or the Fuji-san Effect.
Girl #1: Ooo, that guy's pretty hot.
Girl #2: You think?
But when they get closer:
Girl #1: Oh, no, never mind. Fuji Effect.