Beerfest:
Not horrible...but nowhere near Super Troopers.
Honestly, the funniest part was when someone in our group kicked over a glass bottle they had (we were in a group of about 30...about 20 were drunk).
One of the most crude films I've ever seen. There were young kids (12yrs old or so) in there...DO NOT take your kids to see this movie
Little Miss Sunshine:
While the title might lead you to believe its a "cute" film, the film itself is pretty dark...but in a funny way.
The plot is great. The disfunction of this family adds up to make a hilarious road trip from Albuquerque to ... California (somewhere) for the young daughter's beauty pageant.