I've flown plenty and never had a bad experience per se (although I rarely get worked up over travel problems) and I've had good fortune with mechanical issues (as in they've happened more on the ground than in the air). I do have one fairly memorable event.
I recall flying into St. Louis on a Tuesday or Wednesday night flight on SouthWest about a year into my first traveling consultant job.
The flight had about 15-20 people on it, almost all of them appeared to be seasoned campaigners either heading home after work in Chicago or off to a morning meeting in St. Louis. There had been weather delays into STL, and our flight was already late. Southwest at the time however had what appeared to be an unspoken policy to fly straight through just about everything. So we finally got cleared to fly and we were on our way out of MID.
We got about 3/4th of the way through the flight and it was pretty reasonable, but in the last 30-40 minutes, we started to really get shaken up and blown around. Now I'd been on bad flights before that one, but this one was up there. Even so I was just tired and wanted to be in my hotel bed.
So if you've flown into STL and looked out of the windows on the west side of the plane, you'll see I-70. I like to look out of windows on planes, so as we were landing, I was watching as we were coming down not in a straight line, but at an angle and pretty much getting blown over I-70. Just as I wondered to myself how the pilot was going to correct for this or if I was going to have to deplane on a median, he aborted the landing and gave us full thrust for a full 20 minutes.
I've never ridden in a paint shaker, but I think that that climb out of STL is about as close as I'd like to get.
We landed about 45 minutes or so later in KCI and the captain came back and asked if anyone wanted off and not one person said wanted off. While we waited we hung out in the galley drinking sodas and eating peanuts with the FAs. We finished refueling and flew back with no problems and minimal turbulence. The Hertz guy said we were the first flight he had picked up in 3 hours. I still have no idea how we were cleared out of MID.
That was the probably the roughest flight I've been on, but I don't really recall being scared, or even sick. Mostly I was just bored and tired of traveling.
Now I've had plenty of problems on the ground and funny stories, but nothing that I'd consider horrible.
I did miss the Continental flight from HOU->CMH that slid off the runway in the blizzard of 2008. I was still pissed that I missed it since I got stuck in Memphis and I wanted to be at home playing in the snow, but NWA did pay for my hotel, so I guess it was ok.