For me, it was worth what I paid. I was there in October, first thing in the morning, and it was not crowded. I've also paid to see Lookout Mountain. I paid to ride through the gorge late in the afternoon before, and a camping fee to be around to see the gorge from the top in the morning.
But it depends on your interests, and how you value your money. Most of these attractions cost less than a decent bottle of wine or a six pack of good beer. To some folks that is a lot of money, to others it is trivial. It tend to rather value these attractions not vs the entry fees but rather the time I spent there, and Royal Gorge for me was worth the time spent. Consider that I am a geologist, and have particular interests you may not share. For me, Legoland or Six Flags Anywhere is a waste of time and money, a special geological feature is not.