to know that 50% of them are dirtbags, routinely use recreational drugs, cheat on their spouse, lie about their taxes, have loaded weapons in the house, smoke in bed, let their lawns die, abuse their dogs and are generally losers.

The ratio you point in your OP is nothing. The manner in which the homes are maintained around you is far more important than the occupants when it comes to value, UNLESS you have specific knowledge of a meth lab in the gorgeous house next door.