At a minimum I know San Jose PD, San Mateo PD, Fremont PD all do ride-alongs. I want to say San Mateo County Sheriff might also accommodate.
Edit - I don’t know the specifics around them (ie, if you have to be a current applicant or something) I just know they’ve done them in the past.
Something to note - if you're looking for excitement, you probably won't find it. Your car will be dispatched to welfare checks, neighborhood checks, and maybe do a few low risk traffic stops. If anything does go down, the officer is wearing body armor - you will not be. If there is a life-threatening situation, the officer needs to be sure you won't be a liability. You will likely not be involved in any car chases beyond the first few seconds to where they can get another chase car involved. You will not be serving high risk warrants or anything.
Most of the time will be spent talking with the officer and getting to know them, the neighborhood, the city, the trouble spots and troublemakers, etc. So if you're looking to apply, it'll be a fantastic experience. If you're looking to familiarize yourself with any of the above, it'll be great. But if you're just looking for some risky fun, it's not the way to go.
Posting this more as a general info for anyone reading the thread. YMMV by agency, personal connection, the officer who chooses to take you out, etc.