I'm not making a case for dense urban living. I understand many do not prefer that form of living, in fact I'd say most do not. Something in between dense living and what we are currently building in the US seems most prudent to me, but I'm simply an observer.
My experiences in the suburbs were not remotely near yours, and I spent nearly all my life in them throughout the US - including raising a kid. In my experience, those sorts of vibrant communities only seemed to exist in a few select "older" suburbs (aka suburbs with downtowns) from where I was from. I agree those look great.
It also certainly depends on personality. In my experience, unless you enjoy a very structured social life you simply will not have one. I have seen many folks end up slowly just spending most of their time indoors in front of the TV/computer cut off from the world. This is at least a bit harder to do in an environment not basically built to optimize that condition. I enjoy going out with a friend on a random Wednesday night, but I don't enjoy planning on that activity a week in advance.
It's an interesting topic to me. I think of my Grandfather's house in what could only be called a prototypical suburbs of the 1950's and I can absolutely see that life being amazing. The same life in a 2000's era suburb just seems like an utterly different living experience to me - almost alien in nature when I lived there.
That and the whole financial sustainability of the endless expansionist sprawl is highly suspect to me.