Do you attend NU now? I would say all sororities here "serve a good purpose." Not every one will serve that purpose for you, but with 12 houses (Panhellenic houses, there are various multicultural and Black sororities as well) you're more than likely to fit a great fit for you. Also, I can say with confidence that there is no sorority hazing here.
If you're a current student, not sure where you're getting that perception from (unless this is all based on popular media). Definitely sign up for Recruitment Preview which is in a few weeks, just to get a taste of the process.