My best friend is an INFJ, and we have been friends for 8 years. He is my closest and most treasured friend. But he's gay so we'll never progress into anything more (plus, I've never been romantically interested in him.)
I did date an INFJ for a year and a half, as well, but that did not end so well.
Anyway, it can be a great pairing, or it could be not so great. It really just depends.