What surprised me though is how overall passable public transport in San Francisco was. MUNI and BART are pretty okay for getting around even if locals don't believe so. Unsurprisingly whenever I was in trams, they were full of other European tourists.
Moving around the most urban cores outside of rush hour, you typically won't see the worst of the warts.
i don't remember ever to having had to take a taxi. i got a few rides, but then it was friends who went to the same place anyways (like a linux user group meetup)
i can't think of any places like that in europe. european cities are simply not that spread out. so unless you live on a farm far from everywhere, you should be fine.
Imagine if every city was San Francisco, especially in realtion to income.
In the end, I can live somewhat comfortably if I commute, essentially trading my time for lower crime rates and nicer surroundings.
Also consider that if you are reading HN, you are likely to work in IT, which gives you a skewed idea on average income levels.
berlin is indeed interesting, one would think that with it being the capital city, the demand would rise, but i guess that east berlin is less popular, and that berlin also suffers from the overall reputation of east germany.
Iceland has 824 cars/1000, Finland, 494 and Norway, 616.) The US overall has 811. (https://en.wikipedia.org/wiki/List_of_countries_by_vehicles_...)
BUT, i managed to get an apartment 10 minutes walking from the office. this was in san diego, of all places, a city which is very spread out. a few months later i moved in with friends and we found a place far north. most of my roommates had a car, but i took care that i had a bus going directly to work. it ran only once in 30 minutes, so missing it occasionally was a pain, but it was fine otherwise. it also provided for some memorable displays of humanity. another few months later the company moved to los angeles, and again i found a place with a direct bus to work.
i figured that if i can manage to live in sandiego and LA without a car, then i can do that anywhere. sure enough, a few years later i achieved the same in auckland. another city that is quite spread out and has a lackluster public transport system that rivals the US in lack of options.
not everyone is going to be able to achieve this. as a young programmer i could afford the higher rent in the areas close to the office. (i was a stone throw from hollywood boulevard, and crossed it every day on my way to the office :-)