Joe,
I suppose we were more or less neighbors until Sept. 16 when we moved back to NC after 35 in Alpharetta; we lived right downtown off of Canton St., about a mile out from Academy St.
I don't have a real great answer for you on the family part of the equation. If you're in Alpharetta, take a look at The Manor, White Columns, and Polo. All are now Club Corp properties, as is Brookfield and Atlanta National. I would imagine that the price structure on all of them would be similar and might be above CC of Roswell, but if you can't get there and back easily, it won't matter what CC of Roswell costs, right? And each of those clubs are "full service" clubs; golf, tennis, swim, dining, and in at least some cases workout facilities.
I was a member of Alpharetta Country Club for many years until it was first purchased by Affiniti and then merged with Crooked Creek into Alpharetta Athletic Club, into the East and West courses; after 15 years, I lasted a year and a half after the merger and then left. The problem with that club is that the pool, tennis, and exercise are at the West Course, and no great shakes; the East Course is the better golf and the driving range. I would have a hard time recommending the club to anybody, but it is under new ownership now and may have price structures that make it a possibility.
BTW, the ONLY way to get to and from CC of Roswell from downtown Alpharetta is a VERY back way that avoids Haynes Bridge, Holcomb Bridge, and most of Mansell. Headed south on Main St, turn left on Maxwell Rd, and follow that past the recycling center until it dead ends into Westside Parkway. Take a right on Westside, then a left onto Encore as if you are going to the mall. Follow Encore down to Northpoint Parkway, and take a right, then a left onto Mansell. Follow Mansell a short distance to Old Alabama Connector and take a right, and follow that until it dead ends into Old Alabama. Take a left and CC of Roswell will be on your left almost immediately.
Take this from someone who made a zillion trips to the PGA Superstore from downtown Alpharetta over the years; this is BY FAR the best way to make this trip. By far...