Their SLC used to be one of the smoothest ones I've ever been on but that was several years ago so I don't know if it's aged well or not. The latest coaster added was a Miler from Celebration City that they renamed Viking Voyage.
Pro: Unless they've tamed it, the back seat has some of the most extreme air I've had on a coaster anywhere.
Con: It will destroy your liver/kidneys/spine/anything in your lower back...
Overall, what the park is now verses what it was before Herschend bought it is like night and day. It's nowhere near as good as Silver Dollar City or Dollywood, but they are trying. Herschend added a ton of trees to the park when they bought it and that has helped it not feel like a concrete jungle as much. It will be hot though. I've never been when I didn't think I was going to melt.
To add to what Jay said, get there early and hit the low capacity coasters first and when your finished go back and ride your favorites a few more times. It's not a whole day park (unless the waterpark is open and you want to lounge around) but you can easily kill a half day there with all the coasters and animal exhibits.
Looks like you will miss their Halloween event "Terror In The Wild" (
http://www.terrorinthewild.com/index.html) (by one weekend) which I've heard is fairly good. In the past they've had a trail/maze that went through the swamp that was very well done. I see now that they've changed the route some and given it a new name: Black Death - Scourge of the Vampire so who knows what that'll be like.