I think the primary hazard might still be the American River (for the reason you noted - the northern levees will fail first, intentionally or not).
A big flood on the American will backwater up the Sacramento and could cause flooding even upstream of the confluence.