Would you choose a "no frills" college or university over a typical residential school in the US?

Didn’t NYU used to be that type of University - along with Temple, CUNY and other urban campuses?