By Americans SF is probably considered a car-free, and public transportation friendly city, but as an European I am shocked to see that almost every street more resembles a free-way than a living-space, and not just in SOMA. China-town so far is the only bit that reminds me of an European city in terms of it's street-life.
And I went looking for apartments/rooms to the north of Market street today, and was shocked to see that what could have been an exciting urban neighbourhood (and the only one built to human dimensions, within walking distance from the financial district), is a shady place, the Tenderloin.
It seems a critical mass issue as well, to some extent. In Europe the exciting young people live in the center, in human-sized communities, while in the US even for Europeans that want to be in the city, the city is made unattractive by crime, drugs, and trash in the street.
I guess I will be settling for something a bit further out, the Haight neighbourhood, or something north of Chinatown (people there don't seem to put their rentals/rooms on Craigslist), and a daily commute on the bus. Still pretty central probably on US-terms, but almost a flight to the suburbs in European terms...
(am still looking, if anyone has anything, mail at wybowiersma dot net)