As a homeowner I have zero objections to apartments built near jobs and transit (which also means away from my house). I also don't think apartments directly compete with single family housing. Like, they do, but only in certain situations and at certain levels of occupancy and the economy.

I am strongly opposed to building homes in stupid places, worsening traffic or overburdening infrastructure. This is why I tend to strongly oppose ADUs. If you want to turn my neighborhood into a dense urban environment, fine, but buy my house and my neighbors' houses, bulldoze them, and build proper urban density.

I also have a lot of skepticism regarding our housing shortage. You can go find people making the same arguments about housing shortfalls in 2006(underbuilt for years, new family formation, prices will remain high...). But then something happened, and it wasn't that 10% of Americans suddenly died. Suddenly we had more homes than we needed. Why? Because housing demand is related to economics. Now that we're slowing down reproduction and kicking out or scaring off immigrants we're likely setting ourselves up for another round of oversupply. "Good!" Well, tell that to the soon to be unemployed home builders.