There seems to be a fundamental misunderstanding in this discussion, because to me it seems like we're jumping from "this is really simple" to "it can't be done" and back. Which is it -- is it simple, or is it so complex that it's impossible?
1. Many problems, including homelessness, are relatively straightforward to solve for a willing State entity in a developed country. Everyone in power that says otherwise is simply lying. This is the “this is really simple” part.
2. The people that get elected and are ruling are not willing to fix these problems. And the reason they aren't is that it's really hard for someone who is willing to actually get elected because of the plutocratic nature of the system. This is the “really hard” part. It's not that it's complex, it's that the interest of the people is fighting against the ideology and economic interests of the ones who have the political power to get someone elected.
See, there's no contradiction at all, and reminding people that “yes, we can in fact have nice things” is actually a political strategy to try overcome #2.
If you agree to the end goal, you can pick whatever answer you like to your financing question, it's not really more important than “what color should the buildings be” as the cost would be a small fraction of say IRA or the yearly defense budget, or Trump's tax cuts.
The legitimate question being: what to do with the plutocracy, and to that question I'm afraid I don't think you Americans will see democracy ever again untill you are willing to get back to your revolutionary roots and take it (or at least make the oligarchs scared enough to give up part of the power, which is the best case scenario TBH).