Just in case you haven’t seen it:

The director of Magnolia (Paul Thomas Anderson) actually cast Sandler in a dramatic role a couple of years later (Punch-Drunk Love) that was also received very well. Might be worth checking out if you liked Magnolia (I loved that movie).