Personally, I also really enjoy Sandler's films, they have a certain magic that makes them excellent, of which you mentioned the only one that I have not seen is "Happy Gilmore" I will put it on my watch list. If you want to see him in a more serious role I recommend "Uncut gems" very good.