Having only lived in the SF Bay Area for a few years now, everyone I know that lives in the SF Bay Area refers to San Francisco simply as "the city". They say things like "I went to the city this weekend", etc. So while I agree with the silly capitalisation, I also think it's a losing battle.
It's also not a behaviour unique to the SF Bay Area; when I lived in a fairly rural area (pop. < 10K spread over quite a few miles), the largest city nearby was often referred to as "the city" by everyone that lived outside the largest nearby city (which was Kansas City where I lived).