I think it’s a great film - wonderfully atmospheric, intriguing plot and some captivating characterisation. It has an impressive ensemble cast too, not just Sean Connery and Christian Slater. For me the sex scene was not particularly graphic, but tastes vary hugely on that sort of thing.
I don’t agree with Devoted_to_Jude’s opinion about the film being “profoundly anti-Catholic”. The film portrayed Catholics that were variously enlightened, compassionate, cruel and misguided. In short, a variety of people. In portraying the events that unfolded at one remote monastery associated with one clerical debate involving a particular group of clergy, I don’t think that the film says anything very much about the Catholic Church at that time or in the present day. I enjoyed it as a great story without looking for a real or imagined message.