As long as sanctuary cities/states officials think they can defy the law with impunity nothing will happen. Only when one or more are arrested and prosecuted will the others fall in line. Even the withholding of Federal funds will only steel their resolve as they send their lawyers before sympathetic judges to delay the withholding of funds.
The only way then to economically hurt San Francisco is via the marketplace.