Water -
http://www.imdb.com/title/tt0090297/ - works best after smoking a blunt
The Ice Pirates -
http://www.imdb.com/title/tt0087451/ - all time classic
and my latest favorite:
Burn After Reading -
http://www.imdb.com/title/tt0887883/ - you either hate it or piss your pants