Financial constraints appear to have scuppered a return for the club's former idol, ending the search for a superstar to rekindle support from the fans after high-profile sales