Yorkshire is a HUGE part of the UK - North, East, South and West. All 4 counties have their pluses (and minuses) like anywhere.
Where on Earth does he get his information from that education in the North is not as good as it is in the South? Check watchsted website for very quick and easy access to OFSTED reports. You can search by postcode and county and it shows where all primary and secondary schools are in your search (so easy to navigate if you have a particular area)and their overall OFSTED grading and links to the actual report, rather than searching through OFSTED direct. Of course, OFSTED only gives a brief oversight but it gives you a fair idea as to the success of a school and then checking out schools of choice yourself.
As for value for money, you'd certainly get that if your budget is 550k. But West Yorkshire is a little pricier than East Yorkshire IMO. East Yorkshire (depending on where you choose to buy) gives you easy access to the North, South and West - especially if you like city shopping, countryside walks, national parks etc. Check rightmove and compare the prices.
I live in Yorkshire although I am not a native but I have been here for 20 years this September. I vowed NEVER to return to my roots because there is so much scope here. I love city shopping in York (and Leeds if someone else drives!) but love the Dales, the Moors and the East Coast - it has everything.
I have friends who have moved from the South and vowed never to return. Their biggest reason is because they wouldn't get a lot for their money. I live in a 5-bed 'bespoke' detached house (we're fourth ones here after being built in 1949) with an acre of land (and very lucky to a 'leisure' activity within our house) and for the price that our house is valued at, I would simply get a bog-standard (and by that I mean it looks the same as the rest of the 500 hundred) 4-bedroom house on a housing estate down South!
Have you thought about a holiday here and explore all 4 Yorkshire counties? I could give an endless list of things to do!