I think the house system was a mixed bag there, it kept some people closer to each other than was healthy but it also provided some level of support for a lot of us. I suspect things have gotten much worse since I was there, though. The only honor code I've ever seen work was the largely self-policed "No member of the Caltech community shall take unfair advantage of any other member of the Caltech community" and the administration was clearly communicating that they no longer expected students to be capable of following it. My impression is that the morale effects of that really cut into the effectiveness of a system that had helped keep pranks from escalating to the really dangerous or outright damaging, cheating low, and aggression of any form very rare. It was mostly worked because it was too simple to have real loopholes, the community fetishized it, we got a lot of benefits from keeping it working (take home finals, lab keys, etc.), and fundamentally it kept the peace. The administration still has a page describing it, but my impression is that as a social construct it's a hollow shell of what it was.
TL;DR? The house system was less damaging than most frats due to self-selection for house membership, but that also concentrated some really unhealthy behavior and the rest of us were already pretty broken without the houses helping.