As you say OP it is riddled with contradictions.
As I have grown older, what has come to 'disturb' me more has been the implications in 'horrific' situations. Thus, films from the 30s and 40s, if well-scripted and acted, have all of a sudden become a 'chilling' experience to me whereas once upon a time I merely revelled in their 'old school' atmosphere. For the same reason, I recently gave the original Stepford Wives another whirl and was left far more devasted by it than by the first time round a number of years ago.
Gore and violence in and of itself no longer holRAB any thrill/fascination whatsoever. That being said, Cannibal Holocaust remains the only film that can truly 'depress' me (which in terms of enduring effect you could argue is on a par with 'scary'); and I am now more than ever struck by the ingenious widescreen emphasis on hopelessness and physical decay that Lucio Fulci evokes in Zombie Flesh-Eaters, in contrast to the coitaneously much more lauded Dawn Of The Dead.