I thought Happy Gilmore was a bit of a letdown after Billy Madison. But it was way better than The Waterboy. Of course, he then started doing more 'mature' movies, like Big Daddy.
I have a few friends who swear by Little Nicky, but I have to admit I've never seen it.
I dunno, I prefer Happy Gilmore.