Just look at BART. Very popular in the polls, approved in a landslide, dismal ridership. Why? Because everybody thought that other people riding BART was a great idea- they had no intention of riding themselves.
(Left the Bay ten years ago)
NIMBY-ism about BART was manifested by the peninsula towns, which refused to allow BART in the first place (due to misguided fears of easy access to their towns by transients, potential criminals, etc.)
As opposed to those whose homes and businesses were Eminent Domain'd to make way for the construction, their nearby neighbors who now have loud above-ground train noise beginning at 5am, etc.
Also, I doubt much eminent domain was exercised/abused during the construction. Have you noticed the way the tracks weave, go underground here, run in the middle of a freeway there? Terminals in the outskirts of town? They certainly exercised that power, but it's not like BART runs right through the middle of town.
And new construction becomes old within a few years. There are plenty of perfectly serviceable condo towers of unfashionable age in downtown Chicago with very reasonably priced apartments.
I upvoted kijin's comment. If you want to build another Manhattan full of gigantic buildings with computer cubicles and tiny apartments, do it in LA or somewhere, because it's probably never going to happen in SF.
I understand that other people don't feel that way, but at the same time I think if people were told the choices, which is basically Manhattanization and $1500/mo rent or stay the course and pay $3k/mo, people on the whole would pick the former.
But because it's framed in terms of 'preserving our heritage', it's easy for people to wishfully think that they can keep things the same for free.