Not too much fazes me these days in terms of physical ride hardware. I can't think of the last time I was genuinely scared of a roller coaster, and I even love things like drop towers, for the most part.
In terms of actual ride hardware; the most scared I can remember having been by dry park ride hardware is Falcon's Fury at Busch Gardens Tampa. I love a good regular drop tower, but something about facing the ground on this one really got my anxiety pumping...
I'm also quite reluctant to do anything where I'm not strapped in reasonably securely, however. For instance, I'm quite reluctant to do something like a Skycoaster, or that SCAD tower where you literally just fling yourself down onto a mat.
Perhaps irreguarly for this thread, however, I'm a lot more easily triggered by psychological fear/horror. I know it's stupid, but if we make the jump to psychological fear rather than fear induced by physical ride hardware, then a lot more within dry theme parks scares me. Ghost trains, even the really low-budget ones, never fail to make me feel at least slightly unnerved, and most recently, I definitely found The Curse at Alton Manor at Alton Towers a touch on the overwhelming and unnerving side. The idea of going to a Halloween event or doing a scare maze does not appeal to me in the slightest, due to a combination of the above and a definite phobia of scare actors/costumed characters, and I have never done Ghost Train at Thorpe Park in any of its iterations or The Walking Dead at Thorpe Park post-zombification for similar reasons.
If we make the jump to waterparks, I have more ride hardware types that scare me. Big speed slides really get me anxious; I was shaking like a leaf before Summit Plummet at Disney's Blizzard Beach, and pushing myself off the edge was horrid, and I was also made incredibly anxious by Ihu's Breakaway Falls at Aquatica, a drop capsule slide. I was made so anxious by the capsule itself, and the feeling of not being able to breathe for a good few seconds after the drop due to being submerged by the water was horrible. This probably sounds completely irrational, but I also have an odd anxiety surrounding any waterpark attraction entailing deep water that I'm unable to stand in. I'm a reasonably strong swimmer (if I do say so myself), but I didn't do the Ohyah and Ohno drop slides at Volcano Bay because the idea of dropping into a 10ft pool made me really anxious. I was also somewhat unnerved by the 6ft+ deep pool whose name I can't remember at Volcano Bay (the one that overlooks Ko'okiri Body Plunge); I couldn't stay in there for very long, as even though I'm very able to swim, I was psychologically really put off by the water being deep enough that I would sink very far in it if I didn't tread water well enough...
