Science Museum was good. De Young art museum was great. Legion of Honor Art Museum was killer!
Don't waste your time on Aquarium of the Bay.
MUNI is not straight forward. I tried to use an app called TRANSIT to navigate it but was less than successful.