If I were a homeowner in such a zone and I had just bought into a neighborhood that was zoned single family residential or just sunk 250K into a remodel in the same zone, and then all of sudden a bunch of developers not even from the neighborhood try to lobby to change the zoning, I'd feel shortchanged.
If however, I was given fair notice about 8-10 years before the rule/zoning change that the city had such intent, then I would make financial decisions appropriately (i.e. not buy in that neighborhood, wait to build a duplex/triplex instead of an expensive single family that will be sandwiched in between two four story buildings, etc.). It's like when you buy an iPhone and the next day Steve Job announces the new iPhone.
That said, my main point is that the change that can happen in the Dogpatch/Central Waterfront is orders of magnitude greater than up-zoning tweaks to the Victorian neighborhoods of SF with less loss of character.