It can, but it has to be pretty brutal (like torture...not just your normal everyday shooting films). A good example is the Saw franchise - no sex, tons of gratuitous violence.
On topic - I saw Silent Hill a while back...love the games, loved the first hour or so of the film, but the ending...