The "main attraction" is the "waterfalls" up the Red Reef Trail, into the Cottonwood Canyon wilderness. It's the first photograph, here.
Not surprisingly, by late summer, the waterfall is often dry. There are two spots where steps are carved into the sandstone, to help you attain the next level. The second one goes above what was a pretty substantial pool of water, which psyched me out. Without a potential fall into water, it's an easy traverse. But I was afraid of freezing and/or falling into the water with my camera and phone, so I waited below for an opening to photograph it.
Despite the relatively small number of people there, the wait stretched about 45 minutes, as some groups were very slow to traverse the six or seven steps, and some individuals posed repeatedly for pictures at the top, and one group just stood around talking at the top for about 20 minutes. When other groups were taking their shots, I moved back into an alcove to give them a clear view. When I finally had a break in the people, I spent about two minutes snapping my pictures, then headed back.
To me, I thought it was obvious, if a guy with a camera keeps peeking around, then moving back, he's waiting to take a picture. But either it wasn't obvious why I was loitering, or people just didn't care. Either way, I spent more than half my time on this hike just waiting. Gave me plenty of time to check my exposures, of course. :D
On the way towards the waterfalls, there's a large alcove, at the canyon split. A pictoglyph is to the left of the cave, and a few other pictoglyphs are inside the cave.
Two other "attractions" in this area of Red Cliffs: Dinosaur tracks, and an ancestral puebloan ruin. The ruin isn't much to see; the residence was mostly below ground, so you're just seeing the outline of where the sticks and mud would have made a roof over the residence. The dinosaur tracks are pretty cool, though.
There may once have been more signed viewing points along the Silver Reef trail, but now there's only the one, quite near the start. It overlooks a campsite.
