My experience is from decades ago at a different college, and every college is different (though many nationally-organized fraternities may have some consistency to them), and things change over time. We had 40-50 fraternity houses on campus, with maybe 4-5 "Animal House" kinds of places, a few "snootier than you" places, a few black fraternities that were social organizations without houses, an engineering nerd house, a few Aggie houses, a coed house, about 10-12 sororities. There were also some non-fraternity special residentials - Hillel, Ecology House, Ujamaa, a couple of artsie/music places. About half the male students joined fraternities after freshman year (and there wasn't much dorm space for upperclassmen, so otherwise they'd live in nearby student slums or out in the sticks.) The fraternities had a no-poaching rule that said you couldn't be a member of more than one, which meant that the houses were a bit whiter than average, though the years that my house wasn't full, we did have one or two boarders who were members of one of the black fraternities.
SAE wasn't any of those categories; they did have big open parties (drinking age was still 18, and they were close to freshman dorms, so yay, beer!), and a few noise complaints but not really more than average. I forget if the house where somebody died in an accident involving alcohol and falling was them or their next-door neighbor.