Harry Potter, Rings, Hobbit, etc...all PG7 or PG 13. I let our kids watch them and they've been watching them since they were 4 or 5. I think kids see the fantasy of it more than an adult.
Sure there are scary things in them but these listed movies are in no way horror J.. They are scifi, suspenseful, and mysterious.
When my grandson was 3 his favorite movie was Ghost Rider. Yes, he loved it. I would wake up in the middle of the night and hear something. I'd go in his room and he'd have it playing on his DVD player. He'd have woken up and went to get it then put it in and fell back asleep. He had a small selection of Disney movies on his cabinet that were his, to ruin or keep nice or play frisby with. They were his movies. But for nearly 6 months every time he could get away with it Ghost Rider was in there playing.
He's fine and not scarred or anything so I guess it didn't mess him up.
To me Horror are movies that deal with Satan and occult things and gore like Freddy movies, which I have never ever ever seen.
My husband has first edition Heinlein books so when Storm Ship Troopers came out he wanted to see how the director and screen writer changed it for the big screen. Heinlein wrote the book to speak to the debate as to whether or not a military force was still needed. If you'd have seen the movie after reading the book you would also have wondered if the director and screen writer every cracked the book open.
The movie, so I hear even though I sat right next to my husband through the whole thing, was basically giant bugs eating people, biting off their heads, crushing them, and so forth.
I sat by my husband with my thumbs in my ears and my fingers over my eyes...I seriously did, I promise. The non gory parts I watched. So maybe 15 minutes of the movie.
To me that is horror. Harry Potter and other movies in that genre are feel good movies, okay, I know that seems odd but think about it.
The bad guy has done so many bad things and hurt people that we stand up and cheer when they're defeated and we feel good about the movie because good conquered evil once more.
So, all in all, J., I'd let the older kid watch the movies and you can too. Just have a task you can do when you feel overwhelmed with the images on the screen or the suspense is bothering you.
If you have hand sewing, crocheting, knitting, reading a book, etc....something you can do while you are still participating by able to distract yourself.
My daughter had a sleep over one time and they wanted to watch this cool new movie. I hadn't heard of it, I was very sheltered and innocent/good little christian woman you know....anyway. The movie comes on and I'm making snacks and stuff and I go in the living room where they all have sleeping bags and pillows and stuffed animals and I see this young man laying on a bed and suddenly an arrow or something comes up through the mattress and it pokes out the front of his throat killing him. I'm freaking out of course and they've all seen it except my daughter so I go back in the kitchen and make brownies, cupcakes, pizza, and more. I wander in when I think it's not horrible and then run quickly back into the kitchen area.
I found something like that to do when my ex wanted to watch The Exorcist. Those sorts of movies bother me because if God is real then so is the other half and they do bad things so demons can take over people and oh my, there I go, that's why I don't watch religious types of horror or suspense movies.