If your working south of Tyne then live south of tyne – and vice versa.
I work in Newcastle City Centre and live on the coast near Alnwick. No riding as such from doorstep but 30 min drive to Rothbury area and some secret spots.
Commute to Newcastle on the train from Alnmouth normally at £40 per week.
40min drive to Newcastle.
Id say from what you have suggested – Morpeth, Alnwick, Hexham, larger nice towns but they all do have rough areas (like anywhere really).
Loads of nice places about, Rothbury for riding but no big shops or anything (you may even see some Raoul Moat mourners hanging by the riverside) – Corbridge, Wylam, Warkworth, even up Bellingham area there will be good riding places near (Kileder) but small town – few pubs and local stores.