I didn't go on the Tornado, Mammoth Falls, or Raging River since I was on my own (part of the time I was at the water park, they shut these rides down anyway). However, every ride I did go on was great!
The rides are:
The Constrictor - A fast tube ride. Imagine being inside a snake and going downwards.
Phoenix Flyers - fun tube rides that banked up and down, and went really fast.
MAXIMUM VELOCITY - best ride ever of any water park (that I've been to)! I wasn't sure what to expect, since the Master Blaster let me down in SunSplash, but this more than made up for it! Lots of thrilling bumps! It's a water coaster, like in Noah's Ark, except designed for one or two people. Oh, and it takes your picture during the ride, but you have to pay to see it.
Desert Racers - another mat racing slide. As usual, these are great.
Serpentine Complex/Super Bowl - some tube slides, one has you going down the "toilet bowl" (yes, I know that's not an appealing way to put it, but trust me, it is fun!). Only problem is, although I was going by myself, I still had to carry a heavier double tube up. Still, lots of fun.
Overall, a fantastic water park with great rides. My favorite water park so far.
Food: Snack bars with the standard stuff are here, but the food is a bit pricey.
Transportation: Fly into PHX (Phoenix Sky Harbor Airport). Bus Route 35 (35th Avenue) will take you to the water park, which is on Pinnacle Peak Rd. The buses announce what street it's crossing, so you shouldn't miss it. Be prepared for a bit of a walk though.
Rating: 4.5 out of 5 stars.