Sorry I missed this thread when you posted it @jimmyjazz. Glad you you had a great trip and you're daughters band absolutely crushed it as I told you.
As for bars of that vein, @TornACL, you've found some food ones, especially The Parkside when there are good bands playing.
Sea Star is a super cool spot that is employee owned with great beer and cocktails, very near Dogpatch Saloon
Toronado on Height Street is a world famous craft beer bar I try to visit frequently.
Benders is one of my favorite spots in the Mission. Latin America Club's another.
Kilowatt is another employee owned spot that is a great Rock and Roll bar, a lot of great shows happen there. Surrounded by several good Indian/Pakistani food options. Owners were mostly Parkside bartenders and believe most still work shifts at both bars.
Tempest Bar is cool.
I've long said that The Royal Cuckoo is the coolest bar in San Francisco. Especially Wed through Sun nights when they have the Hammond B3 going. Lots of great food options around there too. Hit me up if you go that way and I'll share some. Thats my neighborhood. I've gotta mention Rock Bar nearby too.
Somebody mentioned Zeitgeist. Best patio in the city to drink beer on the rare sunny day. El Rio may equal it when they get the big parties going back there on the weekends.
Lipo Lounge in China Town is never dull.
Edinburgh Castle & Ha Ra are about a block a part and our pre, post show spots in that area. As is the Cinch Saloon if your not bothered being in a Star Wars themed gay bar.
Further out in the Height my pics would be Molitovs, The Page, Zam Zam, Gold Cane, and Kezar Pub.
If you can make the short drive to Pacifica, I like to go take a walk on the pier to see what their catching, then go to Winter's Tavern for a couple beers and listen to whatever bands are playing. Can be real hit or miss with the bands, but at least there are a couple pinball machines in the back.
Finally, you can come out to Bernal and visit us at St Mary's Pub. I personally have a stake in that place and bartend a shift a week as my side hustle.
Obviously Im a bar guy, and Im sure Im missing a few spots. This is off the top of my head.
And good call on the Crazy Crab Sandwiches. Thats always the tradition if we go to a Giants game.