I did consider CUNY, and was actually accepted there for the MLS program a couple of years ago. To be honest, I decided against going there for two main reasons -- first, the program seemed disorganized and outdated; and second, their archives course offerings didn't seem very strong. Since I have a specific idea of what I want to do, it seems to me that it makes the most sense to find a program that can provide stronger, more specialized training -- which pretty much left me with Pratt or LIU, and Pratt was ultimately more convenient.
In terms of cost, I'm fortunate in that my employer will reimburse me for the cost of the degree. But even with the reimbursement, it's still a serious financial commitment. Believe me, I wish CUNY was a better program for my needs. :/