ok, this is embarrasing, but let me restate the question again.
I have a wife and 2 very young kids, so I would likely need to buy a house at a place with the whole works (tennis, other young kids in the area, etc.) All I really care about is the golf. So are any of the "full service" type country club communities have golf course(s) and facilities that stand above the rest of these types of communities.
I get the feeling that to access one of the better courses would likely require an additional membership at a golf only place.
Brian