A few thoughts, from someone in Yorkshire whose family is in the SW England. I grew up in London, we all moved. By coincidence, DHs parents are not that far from DM (my DFather died years ago). It’s 6 hrs to DM, about 4.5 to my PiL.
1 - raising children without family support is far, far, far harder than I ever imagined. The DC are 8 and 11 now. They are despondently used to the idea that their grandparents have never seen, and never will, attend their sports day, cricket match, school play, class assembly, birthday party etc - even though many of their friends’ grandparents etc are local, and do. There is no support if we are late home or a child is ill.
2-I have come to resent the time and expense every school holiday to travel south. We never see local friends in school holidays because we are always away. The dc Adore their GPs but hate this.
3- As they are getting older, the GPs are becoming more reluctant to travel. With Covid, no one is prepared to go on the train.
4- As the GPs get older they are increasingly they are wanting to see us more and more/need more support. It’s a very long way (exhausting) for a weekend.
5-£270K isn’t mega bucks for York. Check flood zones.
6- A colleague of mine did exactly what you are proposing for the same reason 3 years ago, but to Leeds. They were surprised to find that they were still unable to afford a house, are still renting and are planning to move back. His DP can’t bear being that far from her family. It took a whole academic year to get their dc into the same school.
7- in 20 years, my southern friends have visited once. There have been a few laughs other plans, all abandoned at the last minute. These people largely exist on FB for me now.