The way you said “face reality” implies a lot of delusion.
There’s a lot of nostalgia. Both for what the city used to be and what I potentially can (but most likely won’t) become. The delusion is so rampant that it’s really what causes people to vote you (and me) down. Like objectively speaking sf is a terrible city and many people agree. At best you can like the city but you cannot ignore the fact that there are some pretty horrible downsides for living here and that many many people hate the city.
I will say if you work in tech or are a liberal extremist or you’re gay then it may be worth it to live here but I wouldn’t call it wonderful. You can’t make the city better if you don’t admit the faults.