I'm not sure what to do about Cletus, to be honest. I'd like to say "enforce the laws about making tons of noise and discharging weapons" but I know that can be a fool's errand in some cases. After all, I was a loud student once.
Ultimately I think that neighborhoods near the core of cities need to grow (densify), as they did for most of history, and the existing homeowners can enjoy the consolation of watching their home become substantially more valuable as a result of somebody wanting to put 10 apartments there instead of one house. It's telling that in many places the most desirable neighbourhoods are the ones built _before_ current laws made them illegal.
'course, I just bought a house in the country, so we'll see how that goes.
Also, Cletus was a caricature... Poor people can be quiet and rich people can be loud.
If somehow housing were made affordable everywhere, how would that pattern be maintained? By definition, there would be nothing stopping "Cletus the Slack-Jawed Yokel" (from The Simpsons) from moving to Mountain View, CA.
So you end up with a situation where elite software engineers are trying to sleep, because they have work tomorrow, and Cletus the Slack-Jawed Yokel is keeping them awake by blowing up fireworks or firing his shotgun at 2am. What recourse do you have? You can't kick Cletus out--that would violate all sorts of human rights and so on.
So when you look at it this way, higher price housing is almost inevitable. Before you can have any realistic hope of addressing it, you need to figure out what to do with Cletus!