There is no way to make the city work for everyone. The city has so many constraints on it, there is no way for everyone to be happy.
For one, it's incredibly geographically constrained. Because it's constrained, housing supply is restricted, which drives prices up enormously and displaces the majority of the population. If you open up housing development, and high-rises start shooting up everywhere, the identity of the city diminishes, and it will lose a good deal of the character that most find appealing about it. Maintain development restrictions, however, and you get people complaining about the NIMBYism and extremely high prices.
In regards to the homeless, how do you resolve that? I mean, if your solution is to provide them with housing in one of the most geographically constrained and most expensive places on the planet, well then you're going to contribute to the first problem. If you're going to move them somewhere else, you'll ease up on the housing constraint issues, but upset the homeless population, and a good deal of people who thought that the homeless were perfectly entitled to live in the middle of most expensive city in the country.
What about the culture? The artistic community that had a larger presence in the city a few decades ago absolutely hates the influx of tech workers. Tech has taken root as a primary identity of the city. Does the city work for everybody when the tech workers continue to displace artists, or the artists prevent the tech workers for moving in?
In what way are you going to come up with solutions that "work for everybody?"