Yes, the Narrows hike is truly memorable. But takes a lot more preparation:
Permits required, and there is a tight quota. And you have to arrange for a shuttle to the trail head.

My group had planned on backpacking it and spending a night, but several spooked about leaving our mountain bikes unattended in the park for an overnight, so we switched and day hiked it. I think the day hike was perfect. We did the hike in September.