Who is actually against a great increase of housing in SF? I've never heard that opinion. It feels like it would mostly be landlords.
Take it with a grain of salt because it's reason.com, but this video does do a good job of conveying a sense of how ridiculous the situation has gotten:
calle24sf for the mission:
United to Save the mission: