An SFH in a big city is a luxury, as you say, something has to give. You can't have cheap SFH in a nice neighborhood next to your job for everyone, there is reason why buildings exist