No, it's not "really liberal." SV especially I'd describe as more libertarian: constrained taxes and marginally socially tolerant with a sprinkling of lip service to liberal social issues.

The rest of California is a little bit liberal in some areas, but mainly in aggregate it's slightly to the left of the American mainstream. Which puts it firmly on the right, in my opinion.