I agree with the previous poster. You sound WAY more passionate about the CUNY program.
If I were you, I wouldn't be afraid about moving to NYC. I am bias because I was born and raised here, but I have the experience of moving away to a small town for undergrad, and moving back to NYC and feeling disoriented. Yes, it is big and there is a lot to get used to, but sooo many people have done it, adapted, and THRIVED. So why not you?
The only issue you might run into is the high cost of living. Finding an apartment with a low fixed rent, coupled with the monthly unlimited MetroCard for transportation, and the cost of food, might have you in a bind. So I hope CUNY was generous enough to give you a good stipend to live off of. If they didn't, and your not comfortable with taking out loans, the you might benefit from UC Davis.