It depends on what you are looking for. Assume you’d be living at home and commuting for Macaulay ? Different experience than living in a dorm. And cheaper- SUNY tuition around 7K but can your family afford for you to dorm?
I think Stonybrook may be better because it easier to get internships in NYC due to proximity. Buffalo is far away. Also Stonybrook CS is better ranked. I am not sure the same logic applies to CCNY though.