Basic rule of thumb is that being at uni is better than being at school - doesn't really matter where you go, you'll probably have a brilliant time, because it's better than what you're used to.
I thought Nottingham had a great mix of a nice campus and good town nearby, one of the reasons why I went there. Compared to unis like Loughborough, Bath and Warwick, I'm pretty happy with my choice, but I'm sure places like Manc, Bristol and Liverpool are great too.