Stay away from Pacifica! They are on a cliff overlooking the Pacific Ocean which sounds terrific, HOWEVER over the last 20 years they have had multiple incidences of that beautiful cliff sliding down the hill. But you don't have to worry, if you go over so will your neighbor as he is only inches from your rig. If he sneezes (or something worst) you will hear and maybe smell it. The "campground" is a parking lot, with normal space between slots (supermarket size) don't open you door too fast, you will ding you neighbors rig, and don't look for grass, there is none unless it is coming up between the cracks in the asphalt.
If you don't mind taking BART an alternative would be the Alameda County fairgrounds in Pleasanton. It is under an hour ride via BART to downtown SF. When we lived in Pleasanton we stored our rig at the fairgrounds. They let us use the dump and water when we were departing or returning from a trip. The RV park is small and if there is anything going on at the FG, it will be packed, but if you can get in it is nice, inexpensive and only a short ride to the BART station.
Most anything in Marin county is nice, or go a little further to Napa Valley. If you want a truly great park go south to Monterey. Just north is the small village of Moss Landing. The park is now a KOA Express, but don't let that fool you, it is right on the harbor, a working harbor, you hear the sea lions barking at night and there is almost always a cool breeze blowing. If you go, cross the bridge and eat at Phil's, Phil beat Bobby Flay with his Cioppino! If you miss it you will regret it the rest of your life! Then there is always the Monterey Aquarium.
Dave, Bobbi and Fenway
2005 38' FDTS Alpine Limited, 2016 Jeep Grand Cherokee Limited
Cape Cod, MA