Don't go to Louisiana. They have a 26 mile bridge.
It's actually just short of 24 miles, which is plenty long enough. I've never had problems with the Lake Pontchatrain Causeway - it's low, flat and straight (just like many miles of I-10 to the west of the New Orleans area).
Now, the Huey P. Long Bridge across the Mississippi River... that one will give me the cold sweats. There's also a fairly new cable suspension bridge a few miles upriver of New Orleans; I swear you can feel the damned thing moving when it's windy.