I have driven over that bridge as well and it’s definitely a scary one. Especially since part of it is that metal grating which gets slick in any kind of humidity.
But for me the Bay Bridges is worse (and I’ve driven the Bay Bridge many times, and the Mac only once - so you’d think familiarity would kick in). The Mac has the other lanes in sight, so it doesn’t seem as crazy small. Also, the Mac doesn’t climb as far over the water as the Bay Bridges do.
I actually compare the Bay Bridge more closely to the old bridges in Charleston, SC that connected downtown Charleston to Mount Pleasant. The Grace and Pearlman bridges were quite exciting, the Grace was like a roller coaster. Like the Bay Bridges, the Grace had 2 lanes and the Pearlman had 3, one of which served as a reverse lane for trucks since the Grace couldn’t handle them. They didn’t have the height over the water that the Bay Bridge does (based on my memory), though. Those bridges weren’t replaced until 2005.