Well, I took the tour of McConnell a couple weeks ago. The facilities look pretty complete and varied. They have a soft running track indoors, an outdoor "trail" running track, different pools at different temperatures including one for lapwork. They have a large room of weight and flexibility machines, all computerized so it will remember you and help you remember what you did last time, what your settings are, etc. They have rooms where you can get your golf swing or tennis swing analyzed. There is a slate of classes from low-impact to aerobic, in a room on a mat or in the water, all free to members. Yoga and Tai Chi are available. There is a nutritionist on the floor you can ask questions of or you can set up an appt ($). There is a cafe with all healthy foods and several places to sit and read and relax. The men's locker room was like a spa or men's club with all the toiletries available, hair dryers, sauna, steam room, nicely furnished. Vickie says the women's is similar.
To join, you have to fill out a long questionnaire (20pages?) at the level of depth you can usually get from memory about health history. It also touches on how you feel, your opinion of your own strengths and weaknesses, what your goals are, etc. I believe you get a lot of tests when you join (treadmill, bloodwork, etc.) and then they create a fitness plan for you related to what you are seeking.
While you don't have to worry about the issue of feeling intimated by big bruising weight-lifters or people that look better than you (like in some gyms), you need to be comfortable with the fact that the average age is probably around 60. There isn't as much "eye candy" as you'd get in a normal gym either, if that's important to your motivation.

This isn't targeted at the youngest population although there were kids around and families. There are a lot of people recovering from injuries, going through therapy. There is a large therapy section where they get their work done.
Right now, with a member referral, the join-up charge (and all the testing/consultation) is $150. Normally the testing/join fee is $300. The monthly fee is $78 for the first person in a family, +$50 for each additional. I think that is static.