A few moms from our gym did it earlier this summer. While they thought it was OK, I'm not sure any would do it again.
You will not get to spend a lot of time with your child. You will be sleeping in cabins on bunks with the kids. You'll be eating the cafeteria food (which doesn't look too terrible).
Do you know what job openings they have? The bunk moms room in with the little kids. They have to take them to and from their activities, help them with the cafeteria, deal with homesickness, and basically be "mom" for up to 20 little kids in your cabin. If you don't love kids, probably a tough job.
One mom was a "driver." She had to pick up people at the airport. She also had to transport kids to the hospital and stay with them. One time she was there until 2 AM and then had to be up and available to drive again at 8 AM.
It is a LONG week.