the developers have a significant amount of leverage in this situation. if they can build one large apartment building in a low-density sfh neighborhood, they can take a significant chunk of value off all the neighboring homes. if they can secure land to build several large buildings, they can seriously devalue these homes. when they start looking to buy property for the nth building, the homeowner isn't going to get anything close to the original value.
as a society, we should never have allowed this situation to happen in the first place, but now that we have, it's not going to be easy to solve. until you get to pretty high percentiles of wealth, homes tend to be a large fraction of a family's net worth. to suddenly remove the zoning would be a pretty big hit for these people; a lot of them could get upside-down on their mortgages.
Usually an increase in density in an area will increase land values rather then depress them.
I'm not in the "ban SFH neighbourhoods" camp, but I think we shouldn't have as much of a problem with them becoming denser. Particularly not when the people already living there tend to have the chance to be well-compensated by selling to developers if they want.
This doesn't mean developers should be allowed to let rip either - as one of the other posts says, increased density leads to increased demand for other infrastructure as well.
Basically neither Manhattan nor Houston are really ideal states in my mind. There should be a way to live in the burbs if you want to do that, but I don't think public policy should be vigorously defending the people who do that regardless of obvious social and economic costs.