No because programs have been used more for social engineering purposes (to force single home neighborhoods to transform into dense urban neighborhoods) than to simply provide more affordable housing

Such programs do not exist.

Most towns outright ban the construction of anything than large-lawn single-family residential.

If the people want single-family houses, they'll buy them. If they want duplexes or apartments, those options shouldn't be arbitrarily blocked by zoning codes.