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.