From stainless to the Arctic Monkeys - via Hendo's and Sean Bean - Sheffield has certainly had an impact.