Like most things at Disney, I think it's doing at least once to decide for yourself how you feel about it. Like most things at Disney, though, it's also worth strategizing to avoid a 3+ hour wait for that privilege.
Personally, having done it once I don't consider it an absolute must-do for my next trip apart from my general desire to ride (almost) every attraction at the parks. My issue is that I just have a really hard time suspending my disbelief for motion simulators (my own fault; I studied them as a senior thesis project and deliberately broke the illusion for myself on so many rides to see how they were done that it's just habit now). It's a very advanced, very cool motion simulator, but at the end of the day you're just sitting in a moving seat in front of a big screen (and a seat that doesn't easily accommodate diverse body shapes to boot--I think that was a bad move). I prefer rides that physically move through real space. I know that sounds really negative...I don't hate this ride and I don't consider it a waste of time, I just would much rather spend my time on something with a ride vehicle that moves through real physical space. But I've only ridden it once, so maybe I'll change my mind when I ride it again. I just don't see it becoming a favorite of mine, and if anything I think all the hype made it worse for me.