There is affordable housing all over America. Get it through your head. It’s about nearness to the economic singularity that costs so much not the housing itself.
What do you mean by "economic singularity"? If your goal is being near economic opportunity then Austin has plenty.
It’s not NYC or SF, but this suggests that those would be more affordable if they just built more housing.
It is not affordable if it is located somewhere with no job.
There isn't affordable housing in areas of opportunity. You can easily find cheap housing if you don't care about proximity to jobs or to good school districts.