Having grown up in the Midwest/Rust Belt and then moved to the southeast, I can safely say that older cities up north are more dense and have some aspects of traditional community building. The south - with its pervasive new construction and far-aflung exurbs and cookie-cutter subdivisions - seems to be the absolute worst. Not sure how things are in the middle of the country. The west seems to vary a lot.
But no, I don't really know any place in the US, apart from inner-city NYC, Chicago, SF and maybe Seattle and Portland and one or two other places, that isn't fundamentally car-dependent. Life in the vast majority of the US is quite homogenous in this regard, at a general level.
I'm really hoping to find a place with no cars where unsupervised kids can get run over by them, but I know that might not be possible to find in the US. Dense and walkable would be a decent consolation prize.