S.J.
I have a 14 year old girl we adopted when she was 7 and have done numerous day and overnight camps.
If you use a YMCA day camp, make sure they actually follow through with the field trips and activities planned (talk to the director of the sites, we had one that never did the field trips and switched to one near my husband's work which did all of the field trips).
Local school districts often have fun day camps. School districts and YMCA tend to provide the most consistent, entertaining camps that go along with having a job.
We'd usually throw in a special camp here and there to break up the monotony such as zoo camp or a Saturday Academy Camp (those are super cool).
My daughter did not like Camp Collins but I've heard other kids really do.
My daughter really enjoys Big Lake Youth Camp (which is run by the Adventist Church, my daughter is not Adventist but feels pretty welcome there but definitely a religious theme mixed in with super cool activities). Of all the camps she's tried, this is by far her favorite.