> If you significantly increase the number of units available via ADUs, then there's a lot more options to rent, and the demand to purchase houses goes down, bringing the prices down.

Why would demand to purchase houses go down? People aren't buying houses because they can't find rentals. People buy houses because they want to be homeowners.