At least part of SF is already there, and as posted elsewhere here, at least one developer is taking a crack at using the state code as intended.
https://www.sfchronicle.com/sf/article/How-one-S-F-housing-p...
https://www.sfchronicle.com/sf/article/How-one-S-F-housing-p...
However, if San Francisco does not submit a valid Housing Element by the end of the year, then unlimited density could potentially be available on any lot in the city.