We have gone to Camel Beach the last two Memorial Day weekends, and we have really enjoyed the water park. It is not as well themed as the Disney water parks, but still a ton of fun if you enjoy this type of park (we are a huge swimming family).
The best deal I have found is to buy the tickets at the Camel Beach website...4 for $100 or $25 a ticket.
It is a manageable park as far as doing all of the activities. We have found that doing things at opening (like Disney) means the shortest lines. Not sure the make up of your party (our kids are 3, 7, 12, and 13). The older three love the Vortex Spin Cycle and the Flow Rider.
The other poster is correct that some of the climbing is steep, so it is a tiring day. Something fun and relaxing to do is to ride the ski lift to the top of the mountain - we always go into the little snack place and cool off with an ice cream while enjoying the lovely mountain view.
Have fun!