In Japan, zoning is handled federally; and the result is much more affordable cities. "Why Tokyo is the land of rising home construction but not prices" https://www.ft.com/content/023562e2-54a6-11e6-befd-2fc0c26b3... An overview of zoning practices there: http://urbankchoze.blogspot.com/2014/04/japanese-zoning.html
Housing in Japan is culturally unique. The average house depreciates completely after just 22 years. People just don't buy used houses. It's folly to compare zoning rules when the spirit of the law is so different.
However, YIMBYs only want half of that -- they want Japanese zoning, with American infinite appreciation. Which is disastrous to basically everyone who works for a living.