I could see DS9 making him the problematic old white guy who wants things to be like they were 80 years ago. He comes into town, is greeted with some esteem and interest, and then he starts to wear out his welcome. He doesn't like Klingons or Ferengi, thinks the Bajorans should see the wormhole aliens for what they are, and the Federation types are too cosmopolitan for their own good – the New Humans from his day run amok.
It's only when he starts to notice the caliber of the types who still agree with him that he really starts to rethink his views.
Maybe in another episode when his shuttle stops again by the station he finds he's missing the past too much and starts to drink too heavily. After having one too many he wrecks his shuttle in an accident that nearly kills a Cardassian orphan girl, and, after many nights in the Infirmary when at last she pulls through, he pledges to take care of her and finds new purpose in being more than a tourist in this century.