Put me in the camp that finds the ride boring. I only ride it with a Fastpass, even then it's 50/50.
Almost the only actualy motion is when you are genlty lifted and gently lowered down at the end. Otherwise, as others have said, it's basically an IMAX of a helicopter view. The film quality dates to pre-9/11.
Only the front row is about 40 feet off the ground. The middle row is more like 27feet up and the third row more like 15feet. (these are not hard numbers, just estimates). If you are not in the front row, you can clearly see the feet of the people in the row above you. It is dark, but it's also very easy to look down and see that you are really only a few feet off the ground.
One suggestion if you are scared of heights- consider using the crotch strap. The ride instructions say that only smaller children are required to use it, but the extra strap will likely give you a better sense of being securely held in place. You can politely ask the CM to assign you to the back row, if you are concerned.