My son transferred from a different CUNY 4 year campus. Yes some CUNY colleges have a dorm, but a very tiny percentage of students live in those dorms. Most of your classmates will commute home after class, and you’ll never see some of them outside school. The physical buildings are old. He had some good professors, some bad ones, like most colleges. Biggest issues with CUNY are cost of living in NYC is very high, and in your case you would have to pay out of state tuition as well.
All that said, as an adult employer, I would recruit graduates of CCNY with tech degrees.
You just may or may not love being a student there for 4 years. If you come to the northeast to visit colleges,
take a look.