I live in Haxby, just north of the ring road, 3miles from the Hosp. and have NTL Freedom through dial up and have no complaints at all. If you aren't in their Broadband area you can get this package and I would HIGHLY recommend it. For £15 per month I get unlimited internet use and free calls upto the value of £15 (and reasonably charged after that - though I have rarely exceeded this). You also have to have a BT line and only pay rental on this (about £30 per quarter).
I would jump at their broadband if we could get it here.
I have used this system for 3 years now without a hiccup.
Oddly enough I did have to ring their 50p/minute tech support line yesterday for the FIRST time but they sorted out the prob v quickly - my 3yr old had rather embarrasingly unplugged the dialler and I hadn't noticed, so that was hardly their fault!
If I were you though I would check if you can get ADSL at the BT site if you want BB - I know most of York isn't cabled.