The latency of a geosynch'd satellite is going to be well over 800ms on a two-way link. In fact, my best guess is that it will be over 1s. So two-way satellite sounds neat, but I don't think it can compete with either DSL or cable. The speed of the signals is the speed of light in a near vaccuum.
As to whether DSL or cable it depends entirely on where you live. Here in Fort Collins, CO, I can say with complete confidence that current cable is WAY better than DSL. (DSL is ~800kbps down 400kbps up, while cable is ~2Mbps down and ~800kbps up - and I work with a bunch of techies - trust me, we have a lot of data points on our bandwidth graph). Uptime is about the same for both (about 1 day of downtime per 3 months), and latency is approximately the same for both as well. Most of my coworkers are switching from DSL to cable.
In a couple of years, we should fibre to the curb (FTTC) or fibre to the neighborhood (FTTN) which should blow both DSL and cable out of the water. My neighborhood is wired for FTTN currently (which I always think is strange because we can't get DSL because we aren't on a copper network). I'm not why we can't take advantage of this, but I've heard it's a politcal issue (FCC).