Sheffield and Newcastle are city-based universities with Newcaste being directly in the city centre, largely based around its campus.
I'll go into great detail about Newcastle as it's the city I know best. Don't be left thinking the rest are dumps and can't come close
Newcastle has the status as being the student and party capital of the country. In truth any of those universities can offer all the nightlife you need during three or four years as they're all major cities. But Newcastle is certainly a particularly vibrant and exciting city.
Newcastle is certainly the most attractive of those cities in terms of achitecture in my opinion. It has some of the country's best example of Neo-classical architecture. Although some of it has been lost due to deveopments in the 1970s there's still streets like Grey Street left.
The wider Grainger Town area, which includes Grey street, was designed by Richard Grainger who used Ancient Rome as his model.
http://en.wikipedia.org/wiki/Grainger_TownIt has amongst the highest concentration of listed buildings in the ountry and, with the city centre being compact, it's all within walking distance from the university (with most of the streets being the main shopping streets).
Newcastle has an excellent cultural scene. There are the obvious places like the Theatre Royal - second home of the Royal Shakespeare Company and the Baltic (one of the largest contemporary art spaces of its kind in Europe) as well as the Sage Gateshead - a concerthall hosting genres from pop, to folk, to jazz, to orchestras. But there there are also lesser known places like independent and smaller commercial galleries including the Biscuit Gallery and Tyneside cinema (showing independent and foreign films).
Newcastle also offers easy access to some of our best countryside and coastline. This isn't bias, it's recognised fact
From the coastline of Northumberland (with its castes and long sandy beaches) to National Parks (Nothumberland, Lake District, North York Moors all not too far away) plus the Durham Dales.
This is briefly summarised in the university website
http://www.ncl.ac.uk/about/city/Crime in all of the cities is low, with Sheffield and Newcastle often regarded as being particularly "safe". But it must be remembered that they are still major cities so of course crime still occurs and you can't be complacent. Whereever you are you are unlikely to be a victim of serious crime especially if you take obvious precautions and be sensibe.
Sheffield can also be a particularly attractive city to live in. Although I'm not a great fan of its architecture (classical architecture being non-existent compared to Newcastle
) you are right on the border of the Peak District. So a National Park is within easy distance. It also offers an excellent student union.
My exerience of Leicester and Nottingham are limited, although I do like the campus' of both.
Leicester, Sheffield and Nottingham are too far from the coast for my tastes though
Tram ride? What, the Metro?
Unfortunately travelling by the Metro isn't particularly great as you don't really go through the best of areas. Even when you do go through affluent areas like Jesmond you don't really see the better parts of them. I find this is often true with rail travel in much of the country though