I also applied to schools in the Bay Area. And I hate to say it but I think your feeling is right, your GPA is okay but isn't quite competitive enough for BSN programs. You could keep trying but it's like a shot in the dark. Although they say they always look at the overall application, it still is super tough to get in when there's maybe 900 other applicants who are in the same boat for only like 100 seats. But don't worry because there are other routes to get to the same destination. If I were you, I would just keep applying because you never know when you might get lucky, and expand your options to more ADN programs. I know many of which are lottery based so that will give you an equal chance as someone with a higher GPA. And then I would also consider a back up plan such as completing your degree in a different major (Biology, Psychology, or Health Sciences). Then you can apply when you graduate, and you will be in a position for direct entry MSN programs as well. You could also amp up your volunteer hours and maybe even start working as a CNA to boost your application. But don't stress yourself out too much. Don't worry you will get there, just stay on the right track, be patient and keep at it--you will get there eventually.
Also, I noticed you applied to SDSU. What about applying to more schools in SD? I think there's a lot of great schools in that area. What about Mesa College or Miramar College? Does UCSD or USD have a program? I lived in SD for years, and it's just like SF only much better weather.
I just wanted to add that I am sort of in the same boat. My GPA was 3.3 and is on the low side because I have a previous degree. I knew my application wouldn't be competitive enough to get into BSN/ABSN/MSN right away. I came to terms with that, because I had to be realistic with myself.
So I think the key is to expand your number of schools you apply to, it will increase your chances of getting in somewhere. Don't be picky, there's nothing wrong with ADN, in fact some prefer it because its the fastest route to RN. You can always bridge. This is what I am doing. Nothing wrong with a Plan B.
And if you don't want to move out of CA I totally understand that. I was born and raised here and I lived out of state for a very short while, I felt like a fish out of water. But there's tons of other schools in CA, explore your options! LA/Orange County area is great too.