I lived in San Francisco in the very late 70s through to the 00s. My first apartment share was $50/mo. The late 70s had the dying embers of the Beat Generation and San Francisco was a sleepy town. San Francisco was great in the 80s with a ton of theater, music, dance, art, everything. It was good in the 90s although the late 90s dotcom boom pushed/priced artists out. The 00s became pretty boring and compressed. I moved to Oakland.
I would say that San Francisco is quite nice now, great bones, although too expensive for interesting people to live.