Nah, not really. The first game is very atmospheric and a bit creepy, but it shouldn't scare you. There are a handful of very effective moments that are designed to make you jump, but that's about it.
The second game isn't scary at all, especially if you've already played the first one.
Now go play the first one. It's awesome.