Steer clear of Goole itself - just my opinion (no offence intended to residents) but it's one of a few small towns/villages in Yorks/Lincs that are quite isolated and can be a bit, well, odd as a result. Goole also pretty deprived in places. And good advice about the flooding.
Howden is about 4 miles away and is a lovely village, but quite small. It has a few shops, though, and a good community although the houses become quite spread out outside the village centre. And the train station is a good mile out of the centre.
There are some nice villages as you head towards Doncaster, with the advantage that you are getting nearer the big city lights of Sheffield, although Sheffield iteself prob too far to commute.
I'd look north towards York and Leeds, although again, the towns and villages can be a bit out on their own until you get to the cities.
Oh, Epworth on the Isle of Axholme in N Lincs is lovely, very rural. Steer clear of Scunthorpe though.
I'd say you'd have to visit any that look good and decide if you like their quirks
.