My wife and I (older, retired Americans) moved to the south part of Piemonte nearly 5 years ago. Our experience has been different from some other posters. Our tiny village is filled with people who are not very sophisticated. More then half of them, for example, consider the Piemonte dialect their first language and Italian their second. Very few people speak Italian to each other, preferring dialect. In fact, a few old timers don't speak Italian at all, so it has been hard for us to learn Italian as quickly as we would have liked We almost never see a foreign tourist and hardly any Italian visitors either. Most of our friends were born within a 25km radius. This is exactly the sort of closed society which a foreigner would expect to be less than friendly.
However, we have been more warmly greeted and more accepted here than any other place we've lived in the past; and that includes a great many U.S. cities as well as a couple of foreign countries. Not only have we made many great social contacts we've made a few "really good" friends; the kind who would bail you out of jail at 2:00am or hold a wet towel to you head while you throw up.
Our social calendar is normally too full rather than too empty. We frequently find ourselves having to endure a typical HUGE Saturday dinner at one friend's house followed by an equally gigantic Sunday lunch at another house. This is not the place to lose weight.
Even though our village is very small it has two groceries, two butcher shops, a baker, a hair dresser, a barber shop, hardware store, garden store, four bars, two pizza joints, one fancy restaurant, a flower shop, two tobacco shops, two doctors, a pharmacy, and the best dentist I've ever used.
If you're into disco dancing, a small village in Piedmont isn't for you, but if you're looking for quiet clean country living, you have plenty of choices. To enjoy it, you would have to be able to make your own fun and, like us, be willing to reach out to the local folks. For example, we hosted a garden dinner party for 50 people 6 months after we moved in. I suspect (in fact I know) that many of the unhappy foreign residents in Italy tend to socialize with other foreigners too much and don't make much effort to interact with the local Italians. If you want friends, go out and get some. If you wait for the phone to ring, you may be disappointed but that shouldn't be a surprise to anyone who has moved out of their own comfort zone.
Of course, Piedmont has Turin as well as quite a few large cities so you aren't far from everything you might need if you live in the boondocks or, if you are more of a city type, living in a medium or large city might be a better choice for you, but the cost of living will be somewhat higher.
This part of Italy definitely has four seasons featuring long periods of fantastic Spring and Fall weather and a short period of cold winter weather as well as a short period of hot summer weather. Of course, weather is altitude dependent. We live at 200 meters and I am always happy to see cold winter rain at my house while looking up at the surrounding hills because I realize people up there are dealing with half a meter of snow. This year I used my snow blower only once to clear my long driveway. On the other hand, those living up at 400 meters are cooler in the summer. Last summer I didn't use a fan for sleeping at night, but the year before that I used on for about a month, but we have pretty good ventilation and live in an old stone house. I've also had to use the snow blower more in years past, but not enough to make me want to move further south.
Bottom line: We like it here.