Non-major cities do, but not “small rural villages”.
A town of 100k in Europe will feel livelier than a metro area of 3 million in the US.
Realistically, SF is only a city in it's north-east quadrant. the rest are cute, sleepy suburbs. And I say that as someone who lives in one of those neighborhoods.