Known as a “Scream Queen,” horror star Jamie Lee Curtis thinks scary movies are “awful”