The only way to make everyone happy is to do away with finite housing availability while maintaining the sense of community that living in a district currently provides (if there even is one nowadays). Currently there is no known practical way to do this.
Adding more wards is a band-aid solution. For all
647,345 active players to have a personal house, there would need to be at
least 10,790 wards. This does not include FC houses. There are currently 72.
People have suggested having instanced housing like how we have apartments, but houses are different from apartments in that houses have exteriors. The problem with this solution would be figuring out how to handle per-house instanced exteriors without sacrificing the aspect of being in a neighbourhood with other players.
It's a bad system that many people hate, but it's what people have to live with until some galaxy brain comes up with a better solution. Complaining about a 7 year old problem doesn't help. Instead, think of ways to help solve the problem. Be that galaxy brain.