I just have to say that I generally despise roller coasters, particularly those with drops (I ride Splash Mountain for DH sake but I hate every minute of it)---however, I got up the courage on our recent trip to ride RNRC, and it is absolutely one of my top 3 favorite WDW rides now!! The first time I rode, I just about had a heart attack from nervousness right before the ride began, but then I laughed through the whole ride. It was just pure fun. There were NO big drops, and no pain or fear involved at all! You don't get jerked or knocked around like you do on most coasters, either--that's a big plus for me! I rode 3 times and can't wait to go again.
Try it!