The ex-City man lit up the MKM Stadium at times during his sole campaign with the East Yorkshire club