I thought "The Royal Tennebaums" was fantastic...

On the other hand, I'm amazed that nobody has mentioned "The Waterboy". Both Adam Sandler and Kathy Bates were absolutely horrendous in that movie.