You can’t realistically take a whole city and draw a line down the middle and say “no cars can cross this ever”.
An underpass works well, but is likely to be much more expensive.
I think it works well as long as the overpass isn't too wide. Also, using colours and stone instead of raw concrete on the outside helps.
I don't know SF, but my guess is that market street will have more crossing than our rivers.