Always enjoy flying and generally enjoy a little turbulence too, but I can think of only 3 instances where I was somewhere between perturbed and truly afraid:

1. US 321 landing in SFO in heavy fog. Very low visibility and lots of gusty winds. I have landed in SFO so many times I basically know how long it takes once I feel the descent begin... so I knew we were getting very close to the runway but could still see nothing but fog outside the window, and the plane was sliding around in the wind. Runway appeared out the window at around 150 feet and we landed very hard, but perfectly safely and went to the gate without incident

2. UX CR7 landing at LAS. At maybe 500 feet we abruptly, almost violently, rolled about 15 degrees left, then 15 right, then maybe 5 degrees left then right again, before stabilizing and continuing on for a smooth landing. Was so weird as it came out of nowhere on an uneventful flight. It was almost over before I could get alarmed. I wouldn't have felt much except I knew we were close to the ground

3. In a 6 seater flying out of the grand canyon back to LAS, racing to get out before a thunderstorm would have forced us to find shelter for the night or maybe take a bus back. Pilot told us "Not gonna lie, this one is going to be rough on the way up" and we were tossed every which way like a leaf in the wind. This was probably the only time I was afraid for a sustained period in an airplane