Can someone give me advice on transferring from a Community College to a 4-year college?

Sounds like you’re in good position for CUNY City College.

What about Excelsior Scholarship at a SUNY?
https://www.suny.edu/smarttrack/types-of-financial-aid/scholarships/excelsior/
The other colleges you mentioned may be too expensive. Run the net price calculators. They will require the CSS PROFILE application to determine your family’s financial need.