Depends where you go, what neighborhood. And of course if you’re not from there you’re not gonna get acknowledged the same, just like if you’re a stranger in a rural town you might find the same. I’m originally from NYC, the most urban of urban in my mind. It’s complex and varied. Changes from one neighborhood to the next. Some can be cold and isolating, others have great community and warmth. The best is the myriad of subcultures that are unique, creative, and produce great things. Anything but “normie” or normative. I love going back, but don’t want to live there, can’t handle the energy for too long having lived in the calmer Midwest for many years.
Discussion
Living in apartment and condo buildings the "community" is basically limited to who live in the building/ on the floor. There are people who sleep 15ft away from me on the other side of a wall that I have never met or heard a peep out of.
There is no community in NYC, LA or Chicago, they are simply too large. There is some shallow communities within buildings or blocks.
Rural communities it's common to know everyone in the town and all their laundry good and bad.
Sounds like you are talking about newer or more affluent areas. Many neighborhoods of NYC, particularly in the Burroughs, people live in smaller 4 or 5 story walk ups, brownstones, or townhomes. Some have families and friends in the area for a few generations. They walk the neighborhood and know and talk to people on the street and in shops. Gentrification has made this more rare but it still exists in many areas. Of course different than a small town where everyone can literally know everyone. Pros and cons of each, a matter of preference. Different, not better or worse in my view.