I've played in every tourney they have except the member-guest, because it's $1000 which just seems ridiculous to me. But every tournament they have (including and especially the member guest) is very well attended. The team events (wooden fence, locker room challenge, member-member) are a heck of a lot of fun. Tournaments were how I initially met most of the guys that I play with on a regular basis now. I've never really done any of the social stuff because frankly golf was the one and only reason I joined a club.
I think the membership is great. Most of the members are between probably 45-60 yrs old, but you can find whatever you're looking for. As far as I know I'm the youngest member they have, but I've got groups that I play with that are in their early 30's, and other groups that are in their late 50's+ and they're all great guys.
If you decide to go out and play a round to check the place out and need somebody to play with let me know and I'll be happy to play with you.