Mark:
My friend and I hiked the Narrows last October. It is certainly an adventure. Does require a reasonable sense of balance and some physical stamina. We started early - 10 AM and were done by the end of the day. We noticed several groups of photographers with tripods etc. Though we were avid photographers, I decided that whatever I could get with my Sony RX10Mark lV would be good enough for me (left my Fuji XT1 behind). The current was pretty strong and there are slippery rocks - hence the need for good balance). You need good waterproof waders and a sturdy staff (there were young whippersnappers who were doing everything without these accoutrements but we were dignified senior citizens - don't know how old you are but a good sturdy walking stick helped me at least). The water varies from ankle deep to waist deep and is quite cold in October and the waterproof equipment certainly helped. We rented it from the shops at the entrance to the park. Then of course there is the decision on how far you want to go. We went about a couple of miles or more and returned in time to return the rented equipment about 4 PM I think.
We were glad we did it and it was a great experience. Regarding great images, they were fine but most of them at or near the mouth and cloning skills are necessary since there will be a lot of other people in the picture.
So by all means go, rent the waterproof equipment, don't burden yourself with a lot of camera equipment and check for flash floods - be safe and enjoy yourself but great images, some maybe but there are other places in Zion which have great potential.
Hope this helps.