If you're having lots of trouble with your modem, call your provider, tell them that you're experiencing frequent outages and you'd like to know whether its a SERVER problem or a PHYSICAL CONNECTION problem. If its a physical connection problem, they can check the status of your line, any noise, etc. If its a server problem, then you'll just have to boot them in the arse and tell them to get their servers up.
You can usually tell the difference between the different problems by:
a) If the modem lights are blinking in unison, and the traffic light is off, then its a connection problem. The modem is trying to re-establish a working data band.
b) If the lights are calm and are responsive when you try to retreive something, yet nothing works (eg, webpages don't load, etc) then its most likely a DNS or DHCP server problem, or perhaps a crapped out router.
In case a) Tell them your problem, they'll have to try and fix it... they don't like clients screwing with stuff anyway

In case b) Phone them and tell them that you don't pay them for downed servers.... what really makes them ticked is when you tell them that your phone provider had better server uptimes
Cable outages are the worst... my brother is going to beat up the cable modem if it happens any more often.
Electrical storms are the worst. Anything that would mess up a TV will mess up a Cable modem. What sucks is when my dad vaccuums and it messes up the modem.... that is the absolute worst.
DSL... it depends where you get it IMHO. In Toronto, it sucks.
Cable rules in Toronto... the only downfall is the $35-50/mo.
I've always wanted an OC connection myself... actually the building I worked in (across the street from me) has an OC connection (unknown width)... gawd I wish I could steal it!!! Its connected to the private military network though (bah)
Personally, I don't see any home computers being able to handle OC connection speeds. Our puny PCI busses can't compete with data at the speed of light, so most of the speed would be a waste. And the OC connector boxes are HUGE, not to mention a hassle of wires.