Does it make sense to move (San Diego -> San Francisco)

The Foothill-De Anza community college district has an excellent transfer record to your preferred schools.

Look into the Honors Institute at Foothill: http://www.foothill.edu/hon which would probably be a great fit for you.

Here’s info about the district (Foothill and De Anza are the only two colleges in the FHDA district):
http://www.fhda.edu/_about-us/index

From the link, above, you can check out the web sites of both colleges.

https://www.campusexplorer.com/college-advice-tips/6F325A19/Top-5-Transfer-Colleges-in-California/