Wireless or wire....DSL or cable?
Wireless is a question of whether or not you have a cable outlet(Cable) or phone jack(DSL) in everyroom in the house...but if you have those things in everyroom, the next question you would have to ask yourself is,"Can I afford the cable/dsl modems in every room?" If you only have one computer, then, wire is the way to go. With 3 or more, I would go with wireless. With the new 802.11g wireless standard, its almost worth going wireless period. Now on to the Cable/DSL debate.
Cable
Pros: Great for gaming, and just plain surfing net. Distance doesnt limit speeds. Higher download speeds. Download is somewhere around 300-500Kbs. Ive gotten mine to download at 1 Mbs a couple of times.
Cons: Uploads kill connection speeds, especially during gaming. Speeds tend to fluctuate based on number of people connected in your neighborhood/apartment complex.
DSL
Pros: Fast constant connection. Great for gaming and surfing net. Upload is somewhere around 100-128Kbs.
Cons: Distance limits speed. 264Kbs download max, without upgrading service. Constant connection, does not fluctuate.
I personally like Cable better cause Im a gamer. The reason that constant speed is bad(and good in a sense) for DSL is that you cannot go over 264Kbs, that is your allocated bandwidth, and as you can see, with Cable I have hit 1 Mbs a few times. It depends on the sites that I go to, but it can be done with Cable.
Hopefully I didnt bore anyone with my ranting and raving on the subject...Just want to give someone an educated answer, since my job in military is computers and networking.