J.,
We took our 8,7,4, and 2 year olds to see Princess and the Frog and we loved it. None of our kids were too scared, although our 2 year old sat on my lap through the whole black magic scene. It's a little dark. No comments or bad dreams or anything afterwards, though.
Movie has a timely message about making your own dreams come true versus wishing for luck and another great message about love and family are more important than money and fame.
I think that Night at the Museum was scarier, honestly. If someone has a child afraid of movies like Snow White or Sleeping Beauty, probably should skip this one as well.
My favorite parenting movie website is www.screenit.com . If you don't want to pay for a membership, just scroll to the bottom of the home page and click on "no thanks". You get reviews a week after movies come out instead of a week before and you have to ignore advertisements, but it's free. They don't say whether or not to see the movie, just give incredible detail on what's in it so you can decide for your family.
S.