Introduce him to The Muppets as soon as possible, especially Sesame Street, all the colours and songs and stuff are great for kids. Then let him watch the movie Follow That Bird because it is great and not enough people have seen it.

They are great for young kids due to the voices and colours and they don't even have to get a lot of the jokes in the Muppet movies until they are older.

Even my mom, who doesn't like Star Wars or Lord of the Rings, loves the games. So, you know, family activity

I am wary, now more than ever with my eldest at 4, of "kids movies," because Little Mermaid definitely isn't and Beauty and the Beast I hesitate on but am ok with now. Winnie the Pooh is great and there are several different selections out there to choose, as well as movies. "Piglet's Big Movie" is actually well done.

Lion King 2 deserves mention as it is a more fun, less Hameltesque story. Much more toned down.
If you have Netflix, then it is your friend as there are several children's shows on there, such as Sesame Street, and Cailou, which is my daughter's favorite right now. Cailou is a little more accessible since it focuses on a 4 year old and uses a lot of primary colors.

Emperor's New Groove is a second step movie, primarily for the sarcastic humor, which may be inaccessible.

Also, some of the newer Tinker Bell movies are surprisingly well done.

One thing I'll add is with trying to get my daughters to sleep, especially after a busy day, I would find a show (or movie) that relaxes me. For the most part, the show was MASH and I could lay down, let them cuddle with me, and fall asleep. My wife would complain that I stayed up too late trying to get them to sleep, but it was an incredible bonding time for me and my girls.

If you're relaxed, they are relaxed, I've learned.

I'm assuming this was meant to be ironic, because there's no way in hell I'd show "the Schwarzenegger/Stallone/Van-Damme back catalog" to a 6 or 7 year old.