I live in Wakefield too, although the town centre is rubbish, and I personally think it is in decline even though money has been spent on the mentioned upgrades. However most town centres of similar size are.
The villages further away from the centre are better, and they do fade out into some nice countryside really, particularly towards the south-ish?
It’s all about the location though, I would also add there is probably a bit of a sterotype to the types of house in hebden bridge(Almost Country/Rural Cottage type) as compared to Sandal (“Newer” build housing estate).
I would say that you can drive easily to a number of decent riding within an hour easily. (Out of rush hour obviously).