I always thought I was an acreage guy, but after living in a small town for 7-8 years, I think that's about perfect. Modest house with a decent yard, so I don't have neighbors breathing down my neck, but they're close.
I farm, and so I get my fix of being in the country. Plus an acreage has so much more maintenance. I don't have much free time, and I sure as hell don't want to spend any more of the little free time I have working on or around the house.
I can walk/ride my bike to Fareway, the bank, pharmacy, bar, restaurants, hardware store, etc. Super convenient. I rarely drive in town unless it's raining hard or absolutely freezing. A lot of my friends live in town too, so it's always easy to get together. On almost any given night I can go by so-and-so's house and know there will be a group gathered, bullshitting and having a few beers.
I have zero interest in living anywhere else (house and community) in the foreseeable future.