You’ve got over a billion cubic metres of seawater rushing through two narrow chokepoints (hence the name) twice a day - not Ripple Rock, but not particularly gentle either.
The NV Sulphur port facility and Pembina Canada are near the First Narrows, so it might be viable for modern ships.