Once seen as a model of progressive drug policy, San Francisco now stands as a morbid example of how that approach has gone astray.