My DH and I were invited at the last minute to one of the CM previews tonight. It was INCREDIBLE! We stood on the bridge and had a great overall view. There is definitely a heavy water mist zone down front. I don't know that there is a really bad standing place because the show takes place on the entire lagoon width wise and goes up high. Well, unless you are really short behind the guy who has his kid on his shoulders.
Let me just say, if you try to video or take a picture, you will miss something, there's just that much going on. My DH who is not easily impressed with any kind of show even said that he had a favorite section that he would like to see again from a different viewing spot.
It's late and I'm thinking that if I don't have to move my youngest home from college this weekend, I will try to watch it from Paradise Pier.