I have two totally contrasting tales of Uni!
My degree course completed at Uni of Wolverhampton was ok, but I never really got into the whole uni atmopshere/ethos thing, perhaps because it was on my doorstep and I already had my set of mates in the area. And of course, anything that was going on at the weekend at Uni went for a Burton because of going to the game.
After my degree, I decided to go into teaching and completed my training at Newman University in Birmingham. I had an amazing time, and even though I was still living at home, made a number of friends compared to UoW!
From my experience it is more about the atmosphere created in the uni, rather than where it is based or the course that is offered that will affect your experience!