In So Cal I would say Canyon Lake's backwater is a good place to go to but you have to know someone who lives there. Castaic is nice when there is no wind or other boaters.
As far as Nor*cal goes, we don't have any lakes up here, and the delta is always crowded