I love it here, been here over half my life since uni, love the city and the scenery on our doorstep with the peak District is amazing. I never really lived in hull so don't know it that well, but think both cities are quite different, Sheffield doesn't really have a city centre of note unlike Hull, I really recognise the massive change in the attractiveness of the city centre over the past 20 years, whereas I see shef as more of a smaller version of London, just a massive collections of self sufficient villages all bundled together
Cityzens point on nightlife rings true, never seems to be anything like it was 20 years ago when I venture out, but reckon most of that is just being older now!