Fine for games all the time.
Youtube is fine most of the time from what I've experienced.
Rapidshare, etc. downloading seems to be completely random, even during off-peak hours. Currently downloading from rapidshare at 2 KB/sec.
Not sure what the technical term is, but I can also no longer take full advantage of multi-thread download managers. eg. Mediafire (or other hosts that allowed you to use 10 threads) I would download from at 1 MB/sec consistently on BigTime. On Slingshot AYCE, 100-200 KB/sec is the norm (if I'm lucky)