If you do well, a degree from most of the CUNY schools is well respected and relatively affordable (depending on where you live).
If you’re going to college strictly for training in a profession, start with the profession, figure out what you need to study, research which schools have strong programs in that area, and then research if their graduates actually get jobs and interviews in that field.