That may have been true in the past but his latest work, like "Uncut Gems" and "Hustle" are far from "Happy Gilmore".
But mainly I'd say Adam Sandler is a good actor when he's acting in things other people have written, and he's just having fun getting paid to hang out with friends in nice places when he's in movies he writes.
As long as he keeps switching off between good and dopey, I think he can run his con for a long time.
Con? Interesting word choice there.