I really enjoyed your post! Well, I experienced erotic transference for the first time about a year ago(had been seeing my female therapist for about 6 years by this point): I was working on issues around my sexuality and wasn't quite sure if I was more attracted to men or to women. When I finally had the courage to bring up the erotic transference in a session, the relief was immense! I was able to start to explore my "frozen" sexuality in a healthy, positive, safe way because I knew that I wouldn't really act on my fantasy nor would my therapist remove her boundaries. I can now talk about my feelings for men, women, my fears, my questions, my hopes, and sex.
I think many positive things can come out of it if it is handled in the correct way.