I think the appropriate measure is median sales price, not price per square foot. Cities show that most people can consume much smaller homes than the median new construction in America, but small homes isn’t as much of an option in this part of Texas.
Austin is the least affordable of the Texas metros. The affordable ones are Houston, San Antonio, and Dallas/Fort Worth (basically any major metro outside of Austin).
https://www.zillow.com/dallas-tx/home-values/