Two here:
Durham - late 90s
Best: Small town, my department was fab, college bars = cheap beer and a variety of venues to obtain cheap beer from, the amusement of having "The Castle" as your address didn't wear off, wafting around in a gown for formals was rather Hogwarts-esque
Worst: Small town, horrendous class prejudice and anti-local sentiment, cobbles combined with beer = lots of sprained ankles, better like hills. Tourists, Oxbridge rejects with a chip on their shoulder they'd had to come up to "the north" and some generally obnoxious twats.
Ultra-worst: I went to Klute sober once. It was terrifying without beer to numb the cheesefest
De Montfort - last few years (disclaimer - includes the pandemic which was uber shit everywhere)
Best: My department who were absolutely fantastic, mega supportive, the closest knit group of staff and students and you couldn't have a bad day without people noticing and checking in on you.
Also good: student support services - really good (I had a mental health mentor who was FAB), IT was generally very good, lots of support available from the Library in terms of support with information search skills, statistics, academic writing etc - help without utter spoon feeding, campus has lots going on in terms of random fashion shoots being done or videos being recorded of dancers and other randomness - although an old fart now, I liked that going on around me.
Worst: There are courses where the entry requirements are, to put it bluntly, a bit shit which mean that student services could be full of people who'd been suspended from courses for not realising they needed to reapply for student finance each year etc - took up a lot of time and stopped others getting appointments, the wait for the lift in Edith Murphy, timetabling sometimes thinking that you're Usain Bolt and can make it from one side of the big campus to the other in 5 minutes flat, the UCU strike playlist dance party thing going on outside lecture buildings where the playlist was shite and they were really unpleasant towards students trying to enter the building.