Luck of the draw, IMO.
Travel enough, you'll have great experiences and not so great experiences.

I've lived in France, spent months in the U.K., Spain, the Pacific Rim, South America, Australia, and other not-so-well-known places. People are basically people. You can get lucky and meet great people, or you can get unlucky and meet very rude and ill-tempered people. I happened to get into a fairly rough exchange in a small town in Italy many years ago. A few locals did not like the fact that an American was seated at one of "their" tables in a neighborhood cafe and decided to annoy me. A few towns later, I had a great conversation with a nice man whom was sitting next to me at another cafe. He said he enjoyed meeting tourists. You just never know.

It probably helps to speak the local language, but not always. I speak fluent French, but do have an American accent that I can't totally shake. The French sometimes answer me in English because they pick up on the accent, but I answer them right back in French, because I pick up on their French accent when they speak English. Two way street, right?

I think it does depend on your visit location. You can't judge all of France from Paris, just as you can't judge all of the United States by New York City.