Absolutely stunning show! As for the seating, it really doesn't matter where you sit. If you sit closer to the stage (bottom), you may get splashed but you will also be closer to the action, while at the upper seats, you will have a better view of the entire stage and the ceiling (yes, a lot of stuff happens up there).
The show is about 90 minutes long, and even though tickets are on the pricier side, I'd say that it is totally worth it, since it is a once-in-a-lifetime opportunity to see these great performers and the incredible stage that transforms from a pool, to a tree...to all kind of weird platforms.
I would actually be happy to see the show again!!