I've had DSL for over a year now in Washington, DC.
The install was a pain mostly because of Bell-Atlantic. Thank God they aren't my provider.
I got lucky with it because at the time Covad was doing installs here, they were just trying to get everything in and not worrying about the details so my 768/384 ADSSL line is really 768/768 SDSL. Get about the max upload and download speeds.
Only problems I've ever had was when H*ll-Atlantic equipment fails in the area.
Also, when Covad hooked me up, they weren't doing interleaving on the circuit. So my ping times to my gateway and game servers are amazing.
Some ISPs have listened to the complaints about interleaving and let you get that taken off.
here's a small list of my Counter-Strike pings, there's a lot more sub-50 ones there:
19 0 209.249.117.95 27016 Icehawk hosted Fx/[ de_aztec cstrike 0 of 16
21 0 208.185.73.200 26000 Teamplay.Net East2 as_oilri cstrike 0 of 14
23 0 209.249.117.95 27015 Icehawks [~] Prophe de_prodi cstrike 20 of 20
24 0 206.161.123.223 27015 Nachos.net Clan UD cs_milit cstrike 4 of 14
24 0 130.167.236.56 27015 [NHG] Joe Who? Coun de_afgha cstrike 10 of 20
25 0 63.248.98.153 27015 Circular Luvin cs_estat cstrike 1 of 12
25 0 63.215.149.2 27015 GameWarrior's 56K M cs_assau cstrike 12 of 14
25 0 209.49.108.18 27015 cybertron.teletran- de_dust cstrike 3 of 18
25 0 198.69.131.17 27015 Playway.net Executi de_nuke cstrike 9 of 16
25 0 216.167.2.72 27015 Pyro CS Server de_train cstrike 0 of 16
26 0 63.90.162.245 27015 [UU] Valhalla 2 COU cs_assau cstrike 12 of 12
26 0 207.172.7.92 27016 RCN Public CS Match de_prodi cstrike 0 of 16
26 0 216.25.206.91 27015 Playway.net Air Can cs_milit cstrike 0 of 16
27 0 216.254.95.10 27022 GameSpy - SpeakEasy cs_siege cstrike 11 of 12
27 0 208.241.66.36 27015 [TMF] Swat Server de_aztec cstrike 20 of 20
28 0 209.48.40.245 27015 -Pk- Clan Server cs_milit cstrike 15 of 18
28 0 208.231.27.46 27015
www.natoclan.com (3 cs_offic cstrike 0 of 14
29 0 63.90.162.244 27015 [UU] Valhalla 1 COU cs_italy cstrike 12 of 12
30 0 209.48.42.18 27015 Reverend's CS *7.1* cs_italy cstrike 6 of 13
30 0 136.142.56.66 27015 Counter-Strike 1.0 cs_backa cstrike 0 of 16
30 0 207.168.74.150 27015 [SC]SniperCutter's cs_siege cstrike 0 of 12
30 0 198.82.107.48 27015 Ulozas@payne's DANK cs_arabs cstrike 8 of 14
30 0 216.12.89.62 27016 [LM]ClanHq de_cbble cstrike 9 of 20
30 0 208.231.27.46 27016
www.natoclan.com (4 cs_offic cstrike 0 of 18
31 0 198.69.131.24 27015 Playway.net Operati de_dust cstrike 4 of 16
31 0 216.142.108.17 27015 Clan MoB DeeP - Dus de_dust cstrike 0 of 18
31 0 24.147.31.27 27015 BenTheKuno & Slaugh cs_milit cstrike 0 of 8
31 0 128.253.203.149 27015 Maximus de_aztec cstrike 10 of 24
32 0 216.254.95.10 27021 GameSpy - SpeakEasy cs_assau cstrike 12 of 12
32 0 209.61.192.10 28015 GNG's Tourny Server de_train cstrike 0 of 5
32 0 128.103.113.58 27015 Viagra's Zippy serv de_aztec cstrike 0 of 8
33 0 128.91.70.169 27016 [KAO]Killing All Op cs_italy cstrike 15 of 20
33 0 128.143.128.239 27015 ClanSIG CounterStri de_vegas cstrike 17 of 20
33 0 24.147.26.113 27016 [E=mc2] Dog Pound de_dust cstrike 7 of 12
33 0 198.138.221.64 27016 Domain of DEATH! [D cs_backa cstrike 6 of 16
33 0 209.100.20.7 27015 #1 Quik 1.0 Counter cs_assau cstrike 8 of 10
33 0 207.29.192.102 27015 Elite Forces [EF] C de_nuke cstrike 15 of 18
33 0 24.48.94.62 1025 USMC Server Toms Ri as_oilri cstrike 0 of 20
34 0 205.229.76.160 27015 Counterstrike @ ugo de_jeepa cstrike 0 of 24
34 0 198.45.22.8 27015 [DOA] Counterstrike cs_milit cstrike 14 of 16
34 0 24.128.190.78 27016 NETWORK GEEKS Count cs_milit cstrike 0 of 20