Have had to deal with quite a bit and personally I'll take the "trashy" place over the "trashy" people.
Ideally it'd be best not to have to deal with either, but even if/when such a fairy tale place exists it pretty quickly gets overrun by individuals who never seem to grasp they themselves may be the issue - either their irresponsible lifestyle or their desire to make emotion driven decisions (with expectation that others should have the same views) ...or even the expectation that everyone else should solve their "problems" for them.
As for property value, it always seems that people like a high property value whey they're selling, but when it comes to paying taxes....