In my experience, New Year’s Eve, Superbowl and 4th of July are the craziest, but any of the ones with an extra day off like Memorial Day tend to get pretty busy over the weekend as well. Not so much on the holiday itself though, because the Monday is the day people use to travel back home.
Another busy weekend is the one that comes after the 15th of the month. Many people will have just got paid and didn’t have to throw their paycheck at rent and bills like they do at the first of the month.