As a native San Franciscan who lives in New York, I wouldn't quite say that. SF has a lot of stuff concentrated in a small area, and a lot of interesting places within driving distance outside the city. NYC is bigger and has a lot more things to see and do, especially at night. SF still largely closes up shop by 9-10PM, except for the bars.
Glad that the OP got to Tempest. It's a dive, but it's a serious beer bar for serious beer drinkers. Should've gone up the street to Rosamunde's for a grilled bratwurst while you were there.
Beard Papa is a Japanese chain. Tasty cream puffs. I haven't yet tried to track down a location in NYC, but I assume they're here somewhere.
Glad you enjoyed 21st Amendment and Little Star. Some places in NYC actually sell 21st Amendment, and we figured out how to bake our own Little Star-style pizza at home.
I've never been to Fume. There are quite a few amazing restaurants in the Napa Valley.