I think I've got a fairly good compromise with life in a small village near a medium sized city. Everything I need is pretty close and the village life affords some quietness while the city and suburbs next door provide convenience.
I drive about 40,000 miles around NYC, Long Island and New England throughout the year, so could live just about anywhere in the NE. Like I said, for us, it's a pretty good compromise between too many people and being close to conveniences.