I have yet to ride MMRR or RotR, but on my honeymoon in 2018 I was able to ride FoP. I liked it, but it was like Soarin' in a more uncomfortable seat. My husband was really not impressed. We both prefer full dark rides for immersion. Haunted Mansion is my favorite attraction because it gives me the atmosphere and the sense that all these things in front of me are real and concrete, except the ghosts. His favorite is the Tower of Terror for the same thing: it's all in front of us except for the things meant to be illusions or ghosts. FoP failed to really impress me because I knew I was just sitting on a "banshee" and looking at a computerized scene. It's like how the original Soarin' was all shot with a camera versus the obvious bits of CG in the new version.
Na'vi River Journey felt more realistic and I love the shaman AA, she's really detail and highly animated. To me, it's more impressive to see these awesome AA figures that move so realistically than watch a nice digitally rendered scene on a screen. I respect the people who create these sequences, and it's impressive, just not as immersive to me.