First of all: he said no war movies, and everyone posts The Hurt Locker. That's a war movie. So is Avatar. And Chronicles of Narnia too believe it or not.
Alright, well you said no horror, war, apocalypse, scary or violent films. Let's see...
Eternal Sunshine of the Spotless Mind
Stranger Than Fiction
Donnie Darko
Rocky Horror Picture Show
Inception
2001: A Space Odyssey
Schindler's List (I guess that's kind of a war movie and pretty scary and somewhat violent and is very horrible...but still, it's a great movie)
There's tons of good comedies out there (Animal House, Step Brothers, Superbad, The Blues Brothers, anything Monty Python)
But then again, there's a bunch of great movies that don't meet your criteria. Remember: conflict is entertainment...A Clockwork Orange, Apocalypse Now Redux, V for Vendetta, Pulp Fiction, Fight Club, Lord of the Rings..I could go on and on...
And The Hurt Locker is a freakin terrible movie. If you want to know why, I'll gladly list every stupid little thing that's wrong with it.