I spend a half the year in my Sunnyvale, CA home. I never go to SF to see shows, concerts, etc. Several times a year, when I'm in the U.S., I'll put together a trip to NY, LA, etc, to see several events over a long weekend. And/or go to Tanglewood, Monterey Jazz, Cabrillo music festivals.
People who visit me are shocked to learn that I live 40 miles from SF and never go there. (Especially because I'm a gay man.)
SF really needs to build more housing, and get the homelessness and crime problem under control. Pre-pandemic, SF had 2.5x the violent crime rate of NYC. (That may be different now that crime has spiked in NY.)