Our area of N.J. was mostly single and two family houses, along with random apartment buildings. 20 years ago, state began mandating low income housing for municipalities. This year alone, there are 625 units going up in a 3 mile radius, in addition to several thousand that have been built over the past 5 years.
Traffic and parking are now horrendous. Each new unit brings 1 or 2 cars onto the roads.
This all goes into urban and suburban areas because septic systems and water tables in rural areas can't handle new density.
Multiple units will allow lower income people to rent in Lahaina but at the cost of character and quality of life. What was liked about the area, will disappear. Single unit zoning will price out lower income residents.
Prime example -- my father was stationed in Hawaii from 1937-38. He remembered spending evenings on the beach, listening to music from the few hotels that existed. In the 80's, my parents decided to take an anniversary trip to Hawaii. His reaction that he was sorry they went. It was no longer beautiful.