That will be a scenic drive - for those who can afford the $21 one-way toll. Stateside bridge fans will have to make do with the 60-year-old 24-mile long Lake Pontchartrain Causeway in Louisiana, which costs only the gas consumed in crossing it. I rather enjoyed that drive, the half-dozen times I’ve done it.
https://en.wikipedia.org/wiki/Lake_Pontchartrain_Causeway
The Causeway has a toll, now.