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.

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.