pretty much what's been said above...
If Leeds and you have to live in Leeds City Council areas then stick to the north of town, outside the ring road. Bear in mind that the further east you get the more claggy the soil. Further west into the Bradford district & the underlying stuff becomes more gritty, drains better than N Leeds clay. If Bradford, try stick to Bingley/Baildon/Saltaire & outlying villages such as Harden, Wilsden, Cullingworth. Keighley doesn't have much to recommend it other than the steam railway and Haworth/Oxenhope
Train lines into Leeds from the north & west (best hills!):
Airedale line - Skipton - Keighley - Bingley - Shipley (best avoid the centre of Shipley but Saltaire & Baildon are good) - Leeds;
Wharfedale line - Ilkley - Menston - Guiseley - Leeds; all good, and hilly too. Baildon & Shipley are just down the hill from Menston & Guiseley, rides in one area generally tend to flow in & out of the other
Otley is not on a railway line but Menston isn't far. The A660 into Leeds gets really bad once you cross the outer ring road at Weetwood and will get worse for a while if the trolleybus ever gets started
Harrogate line: York - Knaresborough - Harrogate - Horsforth (Horsforth is nice too)
don't know too much about the southwest (cleckuddersfax) or East (York/Selby)
south of Leeds, no-mans land until you get to Morley
East Ardsley is semi-rural but no railway station even though the east coast main line spur to Leeds goes past the edge of the village; getting into Wakefield area, Wrenthorpe, Outwood, Stanley all ok to good; south of Wakefield I'd only recommend Sandal or Newmillerdam. East of Wakefield is flat & empty. Apart from classy Cas.
Getting from north of Leeds / Bradford to anywhere south of them during rush hour, and vice versa, is a nightmare.
When the M62 is flowing well, it's good. but when it's bad it's a disaster.
if work ends up in Sheffield, don't go any further north than Barnsley - but if you end up in Barnsley you'll need an interpreter