Wow, thanks for all the great tips! We still haven't decided, but we may ditch the waterfront option altogether based on this. I know there are tons of great restaurants in great neighborhoods there.

We'll be visiting the bridge (of course) and Alcatraz (of course) so I think we'll have our view of nice waterviews this weekend!