Our council's camp has an excellent family camp with RV sites (and cabins):
It's very isolated from where the scouts are, so there's not really a problem with helicopter parents. The programming is mostly geared toward younger kids, and is excellent. It was originally intended for families of scouts at camp, and they have priority. But it's open to anyone registered in the BSA.
They do not have any programs geared toward "workcampers." In fact, it wouldn't work particularly well for a MBC, since it's so far away from where the scouts are staying (about an hour walk, or about 10 minutes by car to the closest subcamp where the scouts are).
There's a small amount of interaction with troops, since it's sometimes a destination for troops doing hikes or canoe trips.