I would include trades people also. Yes you're right that many of those places I wouldn't like to live there due to other conditions, but then the question I have is. Are these places how they are due to a lack of big business / wealth driving up housing costs? I'd argue that you could very much have a city be a good place for more average people to live without the expensive cost of living that some industries end up bring to their cities.

Having these higher paying jobs in an area effectively just makes everything else more expensive due to increased costs of living, which just brings us back to square one, if not even lower since some of these low skilled jobs, which are arguably the most important in making an actual city function may not be able to keep pace with the increases. What's the benefit of this