For SoHo, I've had really good luck with netgear. I've had a MR314 up and stable for over a year and a half. Likewise I just setup a MR814 weekend and took me all of 5 minutes and worked like a charm out of the box, plus they've added a lot of good documentation to their web interface.
On the Enterprise side, I'm partial to Proxim's Orinoco (formally Lucent). I did a deployment two years ago and the gear still work great. However, our network guys are moving us to Cisco for a new enterprise deployment.
Like everyone else says, stay away from Linksys wireless gear like the plague. They seem to fail, die, or not talk to anything quite frequently.
Also, it's better to buy all your gear from one manufacutor.
Not that you were thinking about it, but stay far far away from Microsoft's own Wireless gear. To say it sucks....is understating it big time. Not only do you force you to install their fluffy client, it overrides the built-in wireless setting in XP so you have to use their client.