So far, no server set in SF has succeeded. Though, it's up to you whether you choose it or not. I'd rather go for Bayside, El Quebrados and Las Barrancas.
It's probably quite obvious that it has to do with the management of the community rather than the location, though. Servers don't automatically become popular if they're in Los Santos, for instance.