See I've been on rotation at two of the NYC EM sites. They both said the same thing. Each major program in NYC has its own feel. And both programs basically pegged the other programs (and themselves) the same way, so it has inter-rater reliability.
NYP: Great if you wanna do some research out of your residency, but the actual EM experience is somewhat of a clusterf**k since they basically have stretchers covering every free inch of space and a few attendings who may or may not be pawning off all of the work and thinking to the 2nd and 3rd year residents. Literally heard it described as "a third world country warzone within one of the best hospitals in america".
St Lukes/Roosevelt: Considered the "fun" choice. Its the one in midtown (and columbia campus) and probably has the staff thats most dedicated to education. 50% of your time is spent in Roosevelt, which doesnt see many traumas. 50% is spent in SL, which sees plenty. "balanced"
Jacobi: Trauma trauma trauma trauma trauma.
Lincoln: el trauma, el trauma, el trauma, el trauma, el trauma (see what i did there?)
Bellevue: the place to go for psych ER. Also has above average amount of trauma.
Cornell: "You go to cornell to be in a good "A"partment, not a good "D"partment". And that's prob not a hit on cornell at all. I was just over there for an non-academic matter and their ER seems fine. Just the general knock on everything about Cornell. Its always going to be third or fourth place in everything (except cancer, because of MSKCC) within the city because it has little besides the Weil Cornell name to make it unique in the overcrowded city hospital scene.
I dont know about the rest of the places, honestly.