It can't make lots simultaneously more valuable and cheaper to acquire

Existing homeowners won't subdivide and leave. They will split their sfh lot and rent it out. Look at people investing into ADUs

It will be cheaper in the sense that renting a room is cheaper than renting the house when looking at total outlay, but not when looking at sqft ownership

We complain about housing being an asset and instead turn every lot into an investment opportunity