Let me add - Ive ONLY gone during off season, and ONLY gone to the waterparks on weekends.
Honestly - Ive never thought it was intolerable, at all.
That being said - we also arrive at opening, and are gone by 2.30-ish.
We have always chosen waterparks for our weekends, because we've never had bad experiences with it (but again - during off season)