I can remember one that terrified me as a kid (The Omen), but that’s probably not scary to an adult. As an adult I can remember feeling genuinely frightened by two films in the cinema: Ring (Japanese) and Event Horizon. The next level down - tension, some stress etc - there are loads.