Some gems from the intro to an article cited at the first link:
Despite its good intentions, San Francisco is not leading the country in gay marriage. Despite its good intentions, it is not stopping wars. Despite its spending more money per capita on homelessness than any comparable city, its homeless problem is worse than any comparable city's. Despite its spending more money per capita, period, than almost any city in the nation, San Francisco has poorly managed, budget-busting capital projects, overlapping social programs no one is certain are working, and a transportation system where the only thing running ahead of schedule is the size of its deficit.