Thanks to years of mediocrity, the rich footballing history of the club and its city is often forgotten