I'm not a big fan of serious horror or gore so I tend to gravitate toward horror films that use humor and entertaining scares. I thought the first Insidious did well in that regard. Drag Me to Hell, the Conjuring, and Cabin in the Woods were great at offering entertaining, fun horror experiences. I think the scariness of a film loses out when you add humor and fun but I can't recall the last deathly serious horror I liked. Maybe 28 Days Later? Looking back now all the movies I've listed include some sci-fi elements on top of just demonic or ghost scares.