I'm a straight male and I feel the movie was done very tastefully (not a pun) and had a nice story. It wasn't supposed to be an action flick, but it does have a good story though I would have preferred to see it go a little deeper emotionally, but you have to understand that this was a "period" film and given the era the movie was set in, the emotions of the characters make perfect sense. In the 50's and especially in the rural areas, people were very conservative and though a character like Cay would've wanted to be open about her lifestyle, she certainly would've felt restrained to do so, even as free-spirited as she was. And Vivian would certainly have initially felt like a leper as the tug of societal demands and the mores of the era weighed on her. I think it was filmed and written in exactly the same light as it needed to be, no more, no less. A very realistic portrait of the era and a great job, no doubt about it, and highly recommended for viewing, but I would rate it "R" for about 5-10 minutes of sex scenes, maybe "PG-13" for content.
As for the sex scenes, I can't imagine anyone not enjoying it, whatever your orientation. I did, and I'm straight as an arrow (no pun intended there either!)
See how much this out-of-print video sells for on the Net and you'll see the demand this movie still creates, which is more of a barometer of its success than anything else. I can't believe that it ever went out-of-print given the demand for it. You don't see that with just any video, and as a minor collector of rare videos I can say that for a fact.