I admit that I haven't read this whole thread, however I have read enough to get the gist of the discussion. I have lived in New York City and lived in a semi rural community. I now live in Albany which I see as a perfect balance between the two. This is just personal preference obviously, but it strikes the perfect balance of detached single family homes and urban amenities in my opinion.