I'm not sure how you define "small" or "large" neighborhood. But my personal preference, based on a number of difference places I've lived, would be in a community of 80-250 homes. I live in one of those now, and it's good for us. A nice variety of people. I've lived "out in the country"--I grew up on a 63-acre place, a mile outside of a town of 200 people. And I've lived in the heart of cities, too. There certainly are advantages to both extreme, but overall I prefer a manageable-sized neighborhood.
Hope that helps.