I also just took a look at the studentreviews website and not impressed. I looked at a total of 10 schools on DD's list. I understand that they are written by the students themselves but honestly for college students/graduates their writing skills are pretty elementary and their insight rather shallow. Some almost seem vengeful.
College confidential makes me chuckle alot although I have managed to extract much useful information from the forums. It does seem, like a pp said in another thread of this sort, all the students are AP, with 4.0 GPA, and everyone is getting into Ivys

Not a whole lot of action by those with "middle" students.
I'm not sure how to get a good idea of what a school is like. So far, we are using visits, talking to counselors, asking about them in forums like this, doing background information on locations, physical space, dining, dorm sizes, etc.
In the end, every single, without exception, student I have talked to about their college says they love(d) it. I have asked at least two dozen kids, in all phases of their four years, a few already graduated, and they all think they are in the best school.
Maybe, the school is what you make it? I do believe that a student can get a great education in almost every college/university if they set their mind to it. I hope the same can be said about the college "experience" itself.