The vast majority of Call of Cthulhu scenarios will be investigative-horror. Very few, if any, will just be pure horror.
I'd suggest grabbing one or more of the anthology books of scenarios, or at least reading up on them.
Doors to Darkness, 5 scenarios. Mansions of Madness, 5 scenarios. These...