Not primarily for tourists ... SF is like the "Downtown" of the Bay Area - where LA Downtown, Houston Downtown, etc etc. have not much of a "there" there in metro areas of significant sprawl, and the cities themselves are huge. SF has a disproportionately high number of services for a relatively low residential population, which swells on a daily basis by a few hundred thousand people.

As much as the Sunset and Richmond districts of SF are primarily SFR, absent a few tony neighborhoods, they are quite dense, and don't offer much in the front or back yard department.