Having two laptops in the house normally, AND having my GF come visit with her laptop, AND having an AIBO with a wireless card, I find wireless rather handy.
I also set up a wireless system in my GF's student house, as this saves having to run wires in awkward places. I used the same settings for her AP as mine (IE, WEP encryption, MAC address filtering, no SSID broadcasts). That means she just comes down to my place, turns her laptop on, and she's on the network.
The only thing I don't use the wireless for is when I'm transfering large files. Wireless is just too slow then, so it goes back to being wired. Fortunately all the laptops have ethernet, so it's no big deal to do it.