It will vary for transfers to private colleges but it’s true that the SAT is not considered for transfers from California community colleges to any UC school. And nobody would call UC Berkeley or UCLA average! Even the “mid-tier” UC campuses would be considered high end flagships in most other states. http://admission.universityofcalifornia.edu/transfer/index.html
Same for Cal State schools if you wanted to aim for the decidedly above average Cal Poly San Luis Obispo or SJSU or SDSU.