Did this last summer along with the Narrows hike. Both were awesome. I don't remember anything being to terribly scary. There are definitely some pictures that I saw online beforehand that had me a little leery. The view at the top is great. I'll have to dig up some of my pictures but here's one I found online taken from the top looking back down the valley.
And here's a pic of the narrows. It's an out and back hike through the Virgin River (unless you have ropes to repel/climb) but it was hard for us to turn around and go back; the views just kept getting better. I actually took virtually this same picture, and there was a picture identical to this framed on the wall in the inn we stayed at just outside Zion.