Cable over here. I would go T1 or T3 if i had the money. High speed Dial-up is good for websites, e-mail and stuff like that. But if you try to play a game online on dial-up expect bad results.
The best internet connection by far is the Gig pipeline. However, a gigabyte pipeline is only available to nuclear power plants at this time. It's used to quickly exchange and update information between nuclear power plants. Imagine downloading an entire movie in about 10 minutes, and you'll know what a gigabyte pipeline can do.