I know one provider who did fall in love with a client. Into the third year of living together, he was still providing.
We were still vaguely in touch when he intiated "getting together" sometime on a Labor Day weekend. Initially, his partner would have been upset, but I hope that changed.
I said no about "getting together" and still do not know, years later, if it was the right decision.