Well, right now I'm using my neighbors connection, connecting via wireless, since it's working pretty reliably and I'm getting good bandwidth (5Mbps) over Time Warner Roadrunner.
I've got a WRT54G Series wireless router and was using that. I had it setup for Wireless-G using WPA2, but I didn't connected via wireless, because I don't see the point if the router is right there in front of me. Though my roommate used it on occasion with his laptop and another person used it with his iPod to browse the net and watch YouTube videos.
I may get cable again sometime. Right now, I'm getting laid off in a few weeks and as long as this is working perfectly fine I don't see the point in spending $46.95/month for it when my uncle is letting me use his free (he lives in the house next to us).
I've thought about getting a Wireless-N router, but haven't yet. The next time I need a router that is what I will buy. I may even go with something that either has QoS features or can be modded to add Quality of Service.