Depends on one's interests. It sounds like my preferences would be more in alignment with yours - music and art - and yes, SF is almost completely lacking that today. But if one were an active part of the LGBT community - SF is a buzzing option. They have various festivals and events almost daily.

Oakland music scene isn't particularly inspiring either. Definitely more independent music events in run down houses, but quality and inventiveness is too often of questionable value.