There are plenty of startups based in SF proper as you mention, instead of the Valley. It certainly varies depending on the type of person you are, but I would think that in general most tech-minded people would prefer SF-proper to Manhattan (though I do love both).