Does Bay Area have that problem even theoretically? They are quite high up. It's the flat near sea level areas like Florida that are in danger.
A quick Google of "king tides flooding San Diego" shows a couple news articles mentioning National City and Imperial Beach, so your suspicions are probably correct - it's the flatter places down south that everyone forgets exist.