I was a big fan of the most recent Planet of the Apes movies. San Francisco was pretty heavily featured throughout.
Another movie I sincerely enjoyed was San Andreas starring the Rock. It was a big, dumb, ridiculous blockbuster but I loved every second of it. It also taught me that when the power is out, rotary phones still work! (I don’t actually know if that’s true)