What image / reputation does NYU have?

I have heard fancy things about NYU and have heard of CUNY as well ? I know they are great schools for psychology and other majors. However,I would like to know what your experience or opinion is.