Little Nicky. This is one of the rare "dumb-humor" movies I really liked; also, I liked "Mr. Deeds" and "Happy Gilmore". "Waterboy" had its moments ("Water sucks, it really, really sucks!), but I didn't like it a whole lot.
A few friends of mine have seen "The Longest Yard", but I haven't. It's gone from my theaters, so I'll wait for video.