What an interesting question! Off the top of my head, I could see them as friends, but feel that it would be rather one sided, with Faramir filling a role similar to Beleg. But then again Faramir might benefit too from seeing how much worse Turin's life was. Makes his own experience seem positively sunny in comparison.
As it actually was in the end.