I hear ya!
I am the BIGGEST roller coaster chicken. As a matter of fact, I've never been on a real roller coaster...I refuse. I did get on a kiddie roller coaster once at a carnival, and screamed the whole time! All the little kids were wondering...what's up with that strange lady?
Anyway, I got the nerve up to try both Pirates and Indy on my trip to DL. Pirates was just fine. I am glad I tried it and I went on it twice during my trip.
The drop was just like going down a short kiddie slide at a playground. Not bad at all.
Indie, on the other had was a little more rough. Truth be told, I can't tell you exactly what happens on the ride because my eyes were closed 90% of the time. You are in a jeep and it twists and turns really fast. I was sitting in an outside seat and I really had to hold on tight b/c I thought I was going to flip out of the vehicle...I'm sure I was perfectly safe...but I felt like I could go at any time. I might be convinced to try it once more if I go there again, but I'd be very sure I was seated in the MIDDLE...I'm still not sure if I'd be able to open my eyes though..