The San Francisco I experience is full of positive energy. Sure, maybe if you're visiting and stay in Union Square, that's not what you see. But if you live in the residential neighborhoods and work somewhere nice (such as in the Presidio), there isn't another city in the world I would rather be.
It seems to me like working from home has transformed the residential neighborhoods. I recently visited Inner Sunset as was astonished at how many people were out and about.