It's a pretty good uni yes, it's hard to say,it depends what you want to do, as not all universities are perfect at everything,not even Cambridge. It's not as prestigious as some though, because of it's age. But it's courses are very competitive with some at top unis. It rises up the league tables faster than any other uni, which is very good, and in some courses, comes top in the counrty, in the official league tables(which you have to take with a pinch of salt) and the student survey.
As for the city itself, I think it's quite like Norwich. It's a similar size, but it's prettier than alot of other cities, as it's not very 'urban' looking.