I've lived in a few places, both in the city and in the countryside and they are all a mixed bag. The Creuse is what it is I guess; rural, relatively poor, not very good at integration, basic in social outlook except in a few places and these are mostly cliques. The people are friendly and welcoming in the main but they tend to see all non-Creusois as outsiders and it is hard even for the French to integrate. I'm not sure why Indre is any different, but it isn't quite so rural or poor and has larger towns and is in a much more populous region so I expect it has more going on and more services for foreigners, because I expect it has more of them.
Integration services are often one of the first things hit by cuts because they aren't noticed by most people. The Creuse did have a good programme for a few years, but now things are almost back to the situation 15 years ago when we first moved over. i.e. you moved here and so it's up to you to sort yourself out. It was clear cut and fair enough IMO. Nowadays people expect much more help and are frustrated and disappointed when there isn't any.
How to integrate is one of the most overlooked factors for immigrants, especially those without children. It's not a place with a big social scene and "off-season" it is cold, dark, wet and mostly shut. You need to be self reliant, like your own company and have your own transport. It is a very big department with very few people. You must expect to travel to do stuff. Often stuff in another department will be closer than what's on offer to you in the Creuse; this does depend a bit on what you like to do. If you like fishing, walking or motorbiking in the woods, then there is lots of that. If you like socialising in English or specific cultural or arts events then it's going to be thin even in the 10 week season.
This can take a bit of getting used to and some sustained effort on your part. If you sit inside watching UK TV, surfing the net and drinking supermarket wine moaning about how you aren't part of anything, then it will become a self-fulling prophecy. You need to speak French to French people. You need to do the things that happen in your commune, or travel to do what you like elsewhere. You need to introduce yourself to neighbours. Or you need to be happy in your own domain, doing stuff yourself, by yourself - there's nothing wrong with watching TV, surfing of drinking wine so long as you're happy doing those things.
Most people will arrive with no friends, no job and no idea how things work socially. If you are a catholic church goer, have kids, speak French and work at something with a high social status, then things will be hard but you will be able to mix regularly with people with the same interests as you. Not so if you can't speak a word, like cricket, ten-pin bowling, take out curry, going to the pub to talk nonsense about the pope's silly hat. You should have realistic expectation of what you will do here - if it isn't what locals are doing themselves then there is much less opportunity to fit in and mix socially.
I think some of this stems not from the Creuse per-se but from the fact that it is very rural. Much more so than where most people move from the UK. Like moving to western Scotland after living in London all your life. It's not the same. Sure for two weeks in the summer it's great having nothing to do, taking long walks and reading a book everyday, but can wear thin during five months of winter. Consider carefully how you will spend your time once you settle in.