Does Germany count?
We moved to rural North Germany nearly 4 years ago, with 3 children. My wife is German, so that helped a lot, but for me it a mixed thing.
On some sides it is wonderful - We have a home, garden and land that we'd never be able to afford in the UK. We have made super friends and feel very welcomed into the neighbourhood, being invited to all wedding anniversaries, birthdays etc. etc.. The sense of community is much stronger than I experienced as an adult in England (much more akin to the villagelife of my childhood). Our children can now identify the over 50 species of birds we get in the garden, in both English and German. My 6 yr old complained that her toy lamb has the wrong number of teats, as we now live/work with real sheep. Excellent freshly baked bakery breakfast bread culture. Steiner schools are state supported. Last Christmas was +10 degrees.
On the other side it is hard - living in a foreign language makes life shallower, particularly if you are not really fluent (like me). I miss(understand) a lot of what goes on around me and cannot express and share my emotional world. When I make word jokes people correct my error instead of laughing. Employment - very hard to get the same kind of salary/position I had due to qualifications not being recognised. Bureaucracy (maybe better in France, but here OMG!). No PG Tips!!! Embarrassed that my children correct my German. Often being nearly run down due to looking the 'wrong' way on crossing the road. This Easterday was -2 degrees with snow.
On the third side (not sure if good or bad). The bank closes for 1hr 30 for lunch. Half day closing. Many shops do not accept credit cards. Everyone knows/observes what the 'foreigners' are doing.
Overall it has been a move that has given us a much better life. It has come with a deep cost for me, as the least flexible, most English of our family. I have no sense of history or politics here, no sense of social culture. These are deep losses for me.
Maybe the/an answer is to try it out for a few years.