I went to summer sleep-away camp four times. One of them was a church camp (Camp Hardtner in Grant Parish LA - a somewhat hellish place to be in the summer), two were basketball camps (at colleges) - those were each for just one week. The fourth camp I went to was a two-week camp in the mountains in North Carolina that is probably the most traditional 'summer camp' that I went to.
I enjoyed the basketball camps but they weren't really set-up like the NC summer camp was. - they were all about basketball (drills, games, etc.). And while I have fairly fond memories of that NC summer camp, I didn't "love" it and was unhappy for most of it . . . due to what I now know where logistical failures on the camp's part. But because I did not want to return and I know that people that find a camp they love, they go back every year, I'm pretty sure that I just didn't want to go back.
But yes, it's definitely still a thing! My girls (now rising 4th and 6th graders) are about to have their second year going to summer camp, two weeks at a camp outside of Brevard NC where they ride horses and do crafts and sheet. There are a few all-girls camps in NC that really focus on building confident young ladies, which I think is great. Actually quite a few girls from NOLA/SELA go there. My wife never went to camp so she pretty much put it on me to make it happen, but I have been making it happen and I think my girls enjoy and benefit from it.