I can't remember ever crossing a really scary bridge, 'cept maybe my first time across the old Byram swinging bridge near Jackson, but I well remember specific crossings that were very scary. By that I mean that conditions at the time made the bridge more than usually harrowing.
One would be the Huey P Long in New Orleans, during a very thick fog in 1991. It had been raining very hard for a while, and heavy rain all by itself is scarier in New Orleans than in most other places, and as I reached the bridge, at a point where it was too late to turn around, I saw a heavy fog bank ahead. This was on a Friday at about 5:30pm, so traffic was horrendous. I could barely see the cars around me, and I was scared. to. death.
Another would be once across the old Vicksburg bridge, in about 1985. Weather conditions were perfect, but the guy coming at me - who I could see from quite a distance - was obviously drunk and weaving all over the roadway. I almost turned to liquid before that guy passed by.