Sandler can be hit and miss with his comedy movies.... some are solidly funny others are just stinkers... I definitely put Sandler above Ferrell or Black... not that I think everything he’s done is great, but he’s far better on average than the other two.
Yes, “Little Nicky” and “Eight Crazy Nights” were horrid stinkbombs. The thing I like about some of his movies is they do have a heart in there somewhere, usually.