I’ll take the other side of the coin. Check out the build show on YouTube if you haven’t yet. He’s from Austin. He’s all about building science. He recommends a completely sealed attic nowadays insulated at the roof line for Southern climates. No eves, no venting. Make the attic part of the cooling envelope.
If you take that approach, you could probably make the attic work. This would heavily have to be built into the design of the house though. Work to get it enclosed and then work with the hvac installer to get it added to engineer load design. Obviously need power up there as well..
This isn’t something I’d just want to slap together as they’re wrapping up your house build.