Yes, we've had good luck with our Chamber, but it takes time. The key to joining is to participate. Go to every event you attend and start building relationships with other members. Check to see if you can join any committees. My husband joined the committee that calls new members so he gets to make contact with many of them. Our asst mgr is an ambassador and is very involved.
Basically, you'll get out of it what you put into it. It took several months, but now we get regular referrals because we know so many people in the business community.