Cabrini was a nicely located, small, friendly community style hospital in the Gramercy section of Manhattan. It's also closed down due to Berger commission influence. Many considered it a diamond in the Manhattan rough.
North General and Elmhurst are considered lower-tier, workhorse programs. Less than optimal locations (approaching Harlem and in Queens, respectively), mostly foreign grads (not good or bad - just a fact). I've known people from both programs. The reviews are mixed. Nice affiliation with Mt. Sinai (if you like Mt. Sinai, which is another discussion).