After looking into these (and a few other programs) I think we’re going to have to pass on a summer program for S24. There are definite benefits I think he would get from participating in some of them (like helping him figure out what types of majors/careers he is more interested in), but even for those benefits we can’t afford the costs (typically $1700+/week for in person; ~1000/week for online).
Like many lower-upper-middle-class families, strictly on paper we could afford it, but that would mean not affording other things we also need or value. I wish we had enough disposable income to make it work, but not this year.