What I have learned about "affordable housing" in this rural area...
The federal government, during covid, granted $500,000 to this small (pop 2100) town. Some of that had to be used for affordable housing. The house behind me (where I lived at that time) was a small 2-bedroom bungalow, sorely neglected for years, was purchased by an investor/home builder. He applied for funding assistance; did some work on that house, including building an office and small apartment for himself in the very large garage. He called it "affordable" housing.
He rented it out to two unrelated individuals; note there is one kitchen and one bathroom, which they must share. Basically, it is a roommate situation. EACH of these two people pays $1,000/month rent. And the owner now has a small apartment and office from which he can operate his business. Had this house been rented as a single family residence, the rent would probably have been around $1,200/month. He worked The System. The people who now live there are trashing the place, mostly in alcoholic stupors.
I see from the Town Hall Minutes a few months ago that he has also applied for a zoning change to build a 3-4 unit duplex on the adjoining lot, also to be called affordable housing.
As soon as I heard it was to be affordable housing, I sold my house. Three years later, the buyers have sold it. Houses all around it are now up for sale. I wonder why? I am glad I moved out of town when I did. Yes, NIMBY.