Don't miss Pier 23 Café, on the Embarcadero. I'm comfortable here solo. I love the food and drinks, and it's on the bay. Check out the video tour on their web site.
Of course, Pier 39 has a lot of tourist type places, I prefer small local spots.