Nobody in a city deserves their own yard. Public parks where everyone can BBQ make far more sense. Want a dog? Move to Montana, or get a housecat instead.
You seem to want sprawl; cities need density.
The YIMBY movement is strong throughout the Penninsula, between SF to San Jose -- areas previously considered suburbs.
Clearly a 5000 sq ft lot is unacceptable in SF, but where _is_ it acceptable? San Bruno? Menlo Park? Mountain View? Sunnyvale? Pleasanton? Oakland? And for how long?
The article is talking about State laws. Presumably they would apply to all cities, not just SF.
If you're neighbors want to sell for $10MM each to a developer who wants to build an apartment, they should be allowed to. If your other neighbor wants to tear down their house and build a duplex and rent the other out, they should be allowed to. If you want to keep your dog and bbq, you should be allowed to.
The general idea is to allow people the ability to extract the wealth from their property. It's possible that they are "drinking your milkshake" by extracting wealth from surrounding properties too. But everyone was given the same opportunity.