I'm one of those parents who tries not to let my kids watch too much tv, and we don't have cable so I'm completely unaware of everything current. If my 3 years and 10 months old son is going to watch a movie, I want to watch it with him and not go crazy after seeing it a few times, so I basically only let him watch things I know I like. The ones that he's seen and enjoyed were:
How to Train Your Dragon - Big Scary Dragon at the end, but my son loved this movie for months, though he was physically incapable of watching it by himself since he has no concept of a timeline and was always worried the Big Scary Dragon would pop up when I wasn't there.
Despicable Me - Absolutely nothing scary and super cute. He didn't like the second one as much, but I did.
Wreck-It Ralph - Definitely some questionable language ("diaper baby", "moron", "hobo"), but I used it as a teaching experience for words we shouldn't say and he didn't have a problem. The ending is a little scary. This movie prompted the most imaginative play, since he was essentially Fix-It Felix 80% of the time for 2 months straight. He constantly wore a blue baseball cap and carried around a hammer.
The Lorax - Like Despicable Me, the bad guy is not at all threatening, so there's nothing scary about this movie. It also teaches a good lesson about not being greedy.
Cars - Another good, not at all scary movie, with a nice lesson about helping people and being a good friend. He also likes Planes, but not as much.
Since it's getting close to Christmas, we're also occasionally watching the original cartoon How the Grinch Stole Christmas and Frosty the Snowman.
In addition to these, we also request several dvd's from the library, like the Reading Rainbow series that I used to watch as a kid, and the current Little Pim dvds which teach foreign languages. I'm not really a big fan of him learning foreign languages through tv, but he saw this somewhere else and really likes them, so I get them for him once in awhile. He's also a big fan of the Magic School Bus series, which we also put on hold and get from the library occasionally.