Each of our DC will have had different experiences. mumsneedwine, your dd is lucky for having avoided the drugs, and lucky she enjoys clubbing which is something Bristol is famous for. Social life seems to happen in the City rather than on campus. I am not convinced that, other than drama, Bristol had the range and depth of active societies that you find elsewhere.
Mine also played sport for the University, though just one, as training sessions were several times a week, with matches on top. Again probably her flat but this was considered odd, or more specifically "lesbian" which apparently is quite the insult, strange for a London reared DD who counted several out lesbians amongst her friends.
The problem was probably the flat and the alpha character who dominated and who stopped attending after about a month becoming almost entirely nocternal. It was like Yr 7/8 all over again. If you did not go along with the gang, you were out. And sadly DD was the only one strong enough to stand up to it. More unfortunately DD was not used to being ostracised and thought she could stick it out and win people over. She should have accepted she was in an unwinnable situation and have cut her loses and asked for an early transfer.
And yes TizerorFizz, BubblesBuddy was rather strange. You have not been around long so may not have come across her. Her DD had left Bristol even before mine had started. And yet she was convinced nothing had changed and that anyone's DC who struggled was wrong and socially incompetent, which given what we were going through, was genuinely upsetting. The same applied to some other posters whose DC were struggling.
I do not think it is unreasonable to suggest that Bristol does not have the best reputation for welfare support, though it is probably better than it was. (DD was a first year during that period when they sadly had a number of well publicised suicides.)
In short, some current students including Tizer's and mumsneedwine's DCs really love it. Others struggle. It is worth asking and looking around and thinking through what you want from a university.