We had a good experience at O. Henry with two kids, but that was four years ago. It's kind of a self-fulfilling thing. If lots of folks think it's a good school and want to send their kids there, get involved and donate a bit, it's a good school. If the reputation goes the other way, maybe not so great. I would suggest touring the school and asking friends ahead of you about the state of the school before you commit.
O. Henry could greatly benefit from a new building. They were slated to get a rebuild in a 7 year window starting with the 2017 bond, but the current long range plan is in doubt after the school board turned over. The Casis crowd might be light right now because of the PTA funding issues, construction and COVID, but all that should eventually resolve. I think the state leg overruled the AISD policy preventing PTA donations to schools.
Wherever you go for middle school, try to get your kids in an activity that they can do all the way through high school. I'm a big fan of the band program at O. Henry and Austin High. Have them try band and maybe a sport in middle school and they'll probably pick one of those in the 8th or 9th grade to focus on. Once they get to Austin High, the band program has it's own building and it becomes a home for the band kids. Athletics got a big boost from the 2017 bond ... they're no threat to Westlake or LT but it's still nice to see something new at the school.
Many of the "great" programs, at whatever middle or high school you want to talk about, are great because one teacher has put a ton of effort into making it great. Chemistry, physics, government, band, theatre, whatever you hear is "great" about a school is probably due to the incredible efforts of an underpaid teacher. Right now, a lot of those teachers are pretty stressed out and some of them are leaving ... taking the "great" program with them. AISD could make life easier on teachers and focus on trying to get them max compensation, but I don't think they are doing that.
I will say that today's kids, from what I have seen at Austin High, tend to support each other and tolerate differences in people much, much more than when I was in high school.