Alright... I'm just gonna give you my own story first hand on this one. Other experiences may vary...
My mother and I both like broadway musicals, and we wanted to see this. We were certain we wanted to. We'd blown it off on 2-4 past trips, because there was usually a wait, and on our last trip in Feb. we said, "This time we see it!"
That said, we were traveling with a party of 7, and the other 5 people's feelings weren't as strong about it... we all saw it... and... I feel like I never freaking heard the end of it from the other 5. They were whining/complaining the minute we walked out. They still occasionally whine/complain to this day, 10 months later. Complained they couldn't take in beer. Complained it was boring. Complained Nemo was played by a girl. Complained they could see the puppeteers (They WANT you to see the puppeteers!) Complained it was the sole reason we missed other attractions later in the day (which i don't believe it was). Complained, complained complained. Annoying/Frustrating beyond belief.
That said, no one put a gun to their head to go in, but we had all been sticking together as a group for the most part and hindsight is 20/20. *Shrug* We should have just split up and me and my mom should have seen it alone BUT... little did we know that at the time.
As for the show itself... it was alright. I don't regret seeing it. I do regret taking my whole party to see it. I don't feel a need to see it again. I may have enjoyed it more if not for the circumstances. I feel like they try to sell it as equivalent to one of Disney's broadway musicals, like Lion King... and it's not. It's much more truncated and abridged than an actual broadway show is. BUT... that's not to say it's bad. If you're interested, I say go for it! If anyone in your party isn't interested, I say tell them to go ride Dinosaur while you see it without them. Don't take anyone who isn't into that sort of thing in. That's my advice. As responses in this thread go to show, opinions can be very mixed based on what type of person you are. Are you into musical theater and puppets or aren't you? Is your party? Ask these questions before entering.
It's worth doing if you want to do it, but if you take someone who's not interested in seeing it to see it... you may live to regret it. In my completely honest opinion... I do feel like its over-hyped a bit. I've seen lots of Broadway shows, and... this seemed much more quickly paced and abridged, as I mentioned. As other have mentioned also, since the original movie is NOT a musical, some of the songs feel forced and out of place. Too much plot crammed into too little time. Too much plot crammed into song instead of told through story. Some neat and impressive puppet-work though.