Where San Francisco is a proper city, plagued by the many problems you mention, the actual Valley is basically suburbs, with a majority of spotless single family homes, lots of strip malls and tiny (but mostly spotless as well) city centers.
As a European, like you and the OP, I mostly felt out of place in both environments (less in SF, to be honest), I could picture living there for a few years at most, but not forever.