By far, the busiest I have seen a park is Columbus Day weekend at Cedar Point.
The line for Millennium had full queues, extra portable queues set up underneath the last overbanked turn, and then the line went all the way back to shoot the rapids. I think the wait was something like 4 or 5 hours...