The Church is very good. Argento had a hand in the writing and Soavi directs skillfully. Not very gory but the FX are well done including a pretty cool demon creature. Definitely worth it if you like Argento or Soavi.
It's a little slow at first, but still a very good film. I got it because it was known as Demons 3 at the time and I love those films, but it wasn't at all like them. Its more of a slower pacedreligous horror but still worth owning. Plus its got Asia in it.
It depends on your horror tastes. I would say if you enjoyed movies like THE UNHOLY and JOHN CARPENTER'S PRINCE OF DARKNESS, you might enjoy this one. The trailer doesn't do the movie much justice honestly. When in doubt, rent it.