It was one of the weirdest ride experiences I've had. Kind of like a tripping Chance Zipper on crack on fire.
Toward the front of the train on the inside seats, the ride was relatively non torturous. In the back on the outside it was that amazing "please can I have death instead" but fun kind of a thing.
Also, I thought it was the most fun at night, but a lot of that was because of the excitement generated by being on the West Coast Tour and getting a surprise extra night at SFMM that we hadn't planned on. A bunch of us in line together had never been on it before so it was just a really amazing atmosphere in general.
The first drop is definitely worth any suffering that may or may not come after it, IMHO.