The best CSU Nursing programs as a Freshman applicant would be SDSU and CSU Fullerton since they are direct admit.
Based on Nursing.org, these are in the top 10:
SDSU
CSU Fullerton
CSU Long Beach
SFSU
Sac State
Sonoma State
I would also look at the NCLEX pass rate for each school: https://www.rn.ca.gov/education/passrates.shtml
You will get a very good education any of the CSU Nursing programs so apply, see where you are accepted and find the campus that you think is a good fit academically/socially and financially.