Hi anon! I’m going to be completely honest and say that I’ve really only used terrains by voleste and nimitwinklesims. 😛 I’m sure there are tons of other great hood terrains out there, though! Have you already searched Mod the Sims and the neighborhood tag on trappingcrushes? I tend to stick to smaller terrains, since I’m rather slow at playing and building and I prefer the look of dense, crowded hoods. (Of course, filling them with absurd amounts of hood deco helps!)
As for my university hood, I’m using the Plockton terrain by voleste. 🙂