"To be sure, there are some potential pitfalls, such as the possibility of altering neighborhood character. But these can be avoided if the city keeps close tabs on projects, sets standards and makes sure they are met."

Boy that sure is reassuring, not.  

I'm guessing any existing CC&Rs would(provided they're enforced) trump any new city ordinances.