You should be aware that there is a league table of institutions in England which legally call themselves "Universities" but whose de facto
status can effect the marketability of the qualifications they are offering. In the premier league for example, are the traditional
universities of Birmingham and Sheffield. It is not clear from your post whether UCB is part of the original university or some ex "college of higher education" which has recently been granted university status. The same goes for Sheffield (Sheffield Hallam is a former Technical College). The other two locations you mention certainly do not figure in the premier league.
Obviously, the particular course you fancy is a large factor in your decision process as well as the ambiance of the location, but I suggest these should be secondary issues relative to getting value for money from your choice.
Edit: UCB is not premier league