In reply to jamesboyle:
I have lived in Nottingham since 1984. I started in the Meadows (PhD student) and moved to just above St Anns in 1992. The city has the usual problems and advantages of big cities with the following notable advantages and disadvantages:
The crime levels are about average for a city of its size but way overstated in the press (even when the drug gangs were shooting each other...which seems to have stopped now).
City centre is really compact and is excellent for entertainment from high to low brow and has great shopping. Very good for restaurants.
The climbing wall is one of the best of its type in the UK but is small and hence is best for bouldering.
Uni's are both ranked above average for their type; city schools are well below average but improving.
The communities are really divided partly as the middle classes chase the good schools in places just outside the city like West Brigford and the city has a ring of problem estates. This leads to overstated dangers in bad bits (which have cheap housing) and overstated benefits of the 'good' bits. Nottingham has a unique character, independant and slightly awkward and not quite proper northern. There are some bad points that dont get much publicity like some problem communities in some small towns to the north and north east (unless you are worried about the BNP when these communities will be well known to you).
The city has some of the best beer in some of the best pubs in the UK based on a chain linked to Castle Rock Brewery... a big change from my arrival when it was one of the worst cities for beer albeit some good pubs. Sadly a few years back one of the big boys purchased our 100% microbrewery based pub (still not bad despite this).
Football teams are currently very disappointing but the panthers ice-hockey team do OK and the rugby and cricket teams (international venue) have their moments. We have a national water sports centre which is great for canoeists rowers etc (if the Olympic funding needs don't close it). Sports facilities in general are OK.
Commuting, busses and trams are better than average for a city of this size IMHO (except for the posh estates on the outskirt towns). May be the only proper UK city not linked anywhere to the motorway system with a duel cariageway.