I too was a weaker constitution child and had to leave Beetlejuice and Jurassic Park.

I also ended up scared of Leprechaun in a hotel room when I was like 6.

One that sticks out that I've never been able to place, though. I was in another hotel room with my dad and woke up to it. All I remember was a gargoyle or something was killing people and at the end they managed to trap its spirit in a chair and then burned the chair in a fire. I had nightmares about that movie for years after but have never been able to figure out what it was.