Like you, I can’t figure out why people think Adam Sandler is funny.
The sad thing is, Sandler could do great work if he wanted to. Reign over Me is wonderful. And the one where he plays an aging comedian is pretty good, too. But his comedy is just vulgar, not witty. Big Daddy was pretty good, but unnecessarily juvenile at too many points. It got steadily worse after that movie.