Archie - The clubhouse at Riviera has a lot of what you're discussing. All the wedding F & B is seperate from the member use areas except for the overhanging terraces where the guests frequent and are a little noisy, which is only a problem in that it adds pressure to your hitting a good tee shot on 1. There is a great view for the guests though. Bel-Air has a similar upstairs/downstairs seperation of function that works well.
The nicest new facilities that I've seen recently are Mayacama in Santa Rosa, California, and Glenwild in Park City, Utah. Well sited, comfortable, great flow, great facilities, full fledged spas, great food, majestic spaces, wonderfully appointed. In fact, the DMB Associates gang from Scottsdale really get this right at the clubs that they build (Lahontan - Lake Tahoe, Santaluz - San Diego, Glenwild - Park City). I'd pick their brain or check out their sites.
Also, I really loved the intimacy and easy feel to Wade Hampton. The proximity of the great porch to the 18th green leads to camaraderie and banter between those that have finished, and those that are attempting to. Great chairs on that porch too.