Do you want them with your SO, maybe even alone? I would suggest trying it if you havnt, but also take the time to pick out something that you both will enjoy. Who knows where it will lead to?
They do not work for us. I personally find them pretty boring - too much non-stop boring action. I have friends who tell me that they set a nice mood and all I can say is, "to each his own".
I had film major friend in college. They have never suggested a bad movie to me so when my partner bought me a really bad one I asked for suggestions. we have a small colelction of rather tasteful movies, all with plots and decent acting in between the sex scenes.
The ones that are laid out proper with plots are sometimes hard to find so I gotcha on that one there, its like maybe I can find 1-2 decent in a set of a dozen. A pain sometimes to hunt for its worth it.
I haven't seen a good movie in a LONG time. But I have memories of some I have seen in the past that can still get me warm and tingly now. If you can find a good one, I say go for it.
I really love the idea, and movies do turn me (and my dh ) on, but there are so many bad ones out there. I find myself thinking "Is she really into that? Is he really enjoying himself?" and critiqueing the whole movie. I wish there were less emphasis on how they looked and more emphasis on the performers relaxing and not angling for the cameras and acting like they were really enjoying it.