OK, so let's say we have an N network, with all N clients, and a Comcast pipe of 8 megabits per second. N has a theoretical top speed of 540 mbps, let's say I'm getting 250. But, in reality, I'm not getting 250, I'm getting 8. So in a way, unless you have a pipe larger then 54 mbps (the theoretical max of G), it is useless to upgrade to N. Is that correct or am I missing something?

For your Internet connection, that is correct. You are limited by the speed of the connection entering your property, and no matter how fast your wireless connection is, it can't possibly speed that up. However, where it does make a difference is communicating between local computers. Transferring large files between locally networked computers is a lot faster using N than using G - as you can use the whole connection speed. It also allows for streaming (such as streaming audio or TV around your house) to happen faster and smoother. I think (correct me if I'm wrong) that the draft N standards also have a longer wireless range than G currently does. That is obviously a big advantage, as long as you secure the connection.

Gotcha. Thanks