The scariest landing I experienced was at SFO. The airport had been closed by high winds for hours. Even the Golden Gate Bridge had been closed.
When my older model 737 entered final approach, it became evident that winds were still high and turbulent. Aircraft was bouncing and rolling. What scared me was when it began to yaw, as well. Landed safely, even though rough and bouncy.
After parking at the gate, as the stews walked up the isle, I overheard the boss tell the others that during final approach the captain had told her to prepare to ditch.
Sounds like you and I flew into SFO the same day. I was on a smaller plane (one stewardess/United I think) but in the very front row. It seemed to be fishtailing a bit but not too bad.
Turns out someone headed to the same meeting had been in the back. She said the motion was much worse in the back of the plane and some people were puking and others were praying aloud.