I live "in the sticks or something" but still have that AT&T entry level DSL that assassin was mentioning ($19.99/mo. by the way). Only slightly more expensive than my old dialup; way more reliable, and the phone line can still be used. I was on dialup for so long, I just don't visit "high bandwidth" sites, and I almost never try to watch a video or anything (although now I actually can do so with minimal lag). The biggest advantage from my perspective is the download and upload speeds of files, and most websites (falling into the above category in which "high bandwidth" pages are excluded) load pretty fast. I don't even download that much--most of my piracy is done with now--but it's good when I do occasionally need it.
To elaborate a little on how bad it was before: 1 MB would take about 10 minutes on a good day. The wiring here is flaky, especially bad when it rains. I may occasionally have got a "good" (30-40 kbps) connection. Now, with the DSL lite (tops out at about 768 kbps, in reality it's not quite that good, but still, much better than above), I can download as fast as I need to. I really wouldn't want to get much faster due to my computer being a 7 year old laptop, I'd quickly fill it up, and I really hate the prospect of offloading the files that I already have (I don't have an external hard drive [USB is 1.1 anyway], nor DVD burner, and it would just take too many CDs for my patience). So I'm thinking it wouldn't really be beneficial to have a faster connection until I get a faster, more up-to-date computer. But this has been a good one, and priority-wise, a computer is way way down the list.