Comes down to life style, commute and what areas you personally prefer.
Here are the trends:
Personally, Cambrian would make more sense from a ROI point of view.
Santa Clara County does do better than other counties, this is where the jobs are.
If you need a detailed market report get in touch.