Actually having one in my car, I have to say some stand up comedy, as you can listen to it, a 30 min tv episode (like family guy, still game etc) or something short. No point in having a full length film unless you drive long distances.
The idea of a DVD player is great in the car but loses it's appeal very quick!