The story, which might have been an Outer Limits episode or some other TV show, or a short story, opens with a man from the middle dark ages finding himself walking in the European countryside and suddenly confronted by a metal monster (automobile). He is taken to a home where he is fed and interrogated. He remembers being in his fields and suddenly transported to a modern day countryside. The story ends when he is told nobody can help him see his family again,and he hangs himself. He is awestruck by modern life, but makes a comment saying "at least wine hasn't changed".
This was an episode of not-very-good tv show called Psi Factor. I just dug around and the title of the episode appears to be Man Out of Time: http://www.tvguide.com/tvshows/psi-factor-chronicles-of-the-paranormal/episode-3558581/203892/
Looks like it's up on YouTube. As I said, the series was not great, sort of a facsimile of X-Files. But I agree this episode was somewhat moving.