A generation ago, the Royal Research Ship Discovery was the star attraction of Dundee's Waterfront.