Oh no, no, no... Red Riding Hood as in the PG-13, Amanda Seyfried movie?? If that's the movie you are talking about, trust me it's not scary at all and it's not that great... Unless you love the Twilight movies, then you'll like Red Riding Hood.
I'm not much for epic movies, but there I know a few that are good. 300 and Watchmen. Both movies were made from the same director.