It seems staying connected to certain types of wireless routers is a problem with Snow Leopard itself. Both my Rev. C Macbook Air and late 2008 Unibody Macbook Pro would connect and stay connected to my work router without any problems, never having any trouble connecting to the internet. Once Snow Leopard was installed on each, neither will stay connected to the internet on the same router for longer than a half hour. I've tried Leopard to Snow Leopard upgrades, as well as fresh installs of SL. Nothing remedies the problem. However, as soon as I downgrade back to Leopard on either machine, the connection issues stop. And the connection issue is specifically in regards to internet connectivity, as when I lose the ability to connect to the internet on Snow Leopard (when the problem occurs), I still have the ability to connect to any other computer on the network. This same problem occurs on the wireless router at my mom's house, as well as one of my friends houses, but not on my home router or my Verizon MiFi router. I've tried every fix listed on the forums here regarding "Snow Leopard wireless problems", but none work. The only short term fix I've found is to turn off the Airport adapter in each laptop, wait about 30 seconds, the turn it on again and reconnect to the network. But quite often this only lasts a few minutes before the problem reoccurs. It's even present on a brand new machine, as I just purchased one of the $799 Microcenter deal Unibody White Macbooks last night as a kick-around machine, and it shows the same problem under Snow Leopard. There's obviously something that has changed in the way Mac OSX interacts with routers from Snow Leopard to Leopard.
Edit: I should add that this problem has been with each of my machines (Macbook Air and Macbook Pro) on each version of Snow Leopard, 10.6.2 included. The new Unibody white Macbook is on 10.6.2 and having it as well.