you're missing the part where more demand creates more supply.
Sure, sometimes the market is distorted due to zoning, like in SF, and also land is finite, but generally speaking the market responds to the added demand by creating more housing, possibly denser housing. Same with other goods. Those are not empty dollars that got added into the system by fiat - they represent additional productive work done, and the goods / services they create is added to the economy.