I think some universities definitely have a reputation for hard partying, others less so, but, as in any institution or organisation, they will all have a wide mix of different personality types and interests, whatever their reputations.
My friend's ds is at Newcastle, which I think is considered a party uni, but he's pretty quiet and studious and enjoys life there. He likes the location, not because of the bars, clubs, drugs, etc, but because it's near the coast and easy to get into the countryside & he's joined some outdoorsy societies and met people who share his interests.
I'm not sure how you would tell from a uni open day that there was a big drugs culture there? But I agree that a large number of people in the UK (not just students) have a worrying relationship with alcohol. I'm a non-drinker, mainly due to MH issues which make me panic about feeling out of control, but I understand why people drink to unwind and relax. But binge drinking seems insane to me & I do worry about the pressure on young people to drink excessively. My impression from friends in other countries (France, Holland, Belgium, Australia & others) is that binge drinking is a much bigger issue in the UK than elsewhere - but maybe that's a huge generalisation.
Regarding squalor, does she mean the run-down state of the buildings and campuses? I've been to lots of uni campuses in the last couple of years, some for work, some for open days with dd. There's a big variation - some have lots of new buildings, lovely open spaces, bright and clean accommodation, good facilities, others are a bit run-down. Tbh I don't think that's a major issue for student experience. I'd be looking at the course, department and the general feel of the campus and city rather than how modern and well-maintained the buildings are.