Tax breaks for filming and it's not SF specific or even cities. Other planets too, like Stargate SG-1 being filmed around Squamish 1 hour away.
Of course, nothing can beat the thrill of waking up every morning and looking out my bedroom building at the office building that was taken over by an evil computer on X-Files.