Frankly, the only film with Adam Sandler I've ever really enjoyed was Little Nicky. There is just something wonderfully comedic about seeing "...a dear sweet man. Mr. Henry Winkler. COVERED IN BEES!"
Billy Madison had it's moments (a few, anyways - mostly Brigitte Wilson's doing, though, and not due to COMEDIC value
), but
Happy Gilmore was HILARIOUS, IMO. The Bob Barker scene alone was worth the price of admission.
I really didn't care for
Little Nicky or
Mr. Deeds (caught most of each on one of the movie channels), and couldn't take more than 15 minutes of
You Don't Mess With The Zohan. Utterly terrible. Fortunately, I didn't pay for it (we get free On Demand movie channels from our TV provider - Cox Cable at the time, though FIOS, who we're with now, does the same).
For a real change of pace from Sandler, which I thought was pretty good, try
Reign Over Me, with Don Cheadle. Adam Sandler in a SERIOUS role - who knew he could actually act?