15 years on, I now love living in such a rural area (and also married with kids!) but it's pointless if you want to easily see the latest bands, have a large and sophisticated social circle, easily meet people you do non-rural business with, enjoy the latest in fashion or food, easily travel to other places without driving, etc..
On the flip side, I can easily go off roading, take my daughters to see farm animals every week, zero traffic jams, low crime, low cost of living, etc, so it's all swings and roundabouts! (And we even have fibre Internet, oddly, so it even ticks my geek box ;-))
A friend of mine recently moved him and his start up from London to Keswick and is loving it - it's all about aligning where you live with whats important to you.
ps. Given the love of football up here (sadly) you'll be needing that foot of yours!
This is not in any way a slight against either Yorkshire or Newcastle. Just an observation that one man's meat is another man's poison.