My $0.02, YMMV (your mileage may vary). It's completely different from place to place. There are places (with and without a residency, mind you) that consult for anything and everything. And then there are places that DO everything. I made it a point to find that out before applying to residency, because I did NOT wanna end up at a place that consults everyone. What kind of procedural skill do you think you'd end up with at a place like that? That's where the "ER doc = phone a friend doc/glorified triage nurse" rep comes from. Granted, everything has it's place. When you're getting killed with sick patients, spending 20-30 min doing a procedure may not be the best use of your time, when you can see a few very sick patients and get their workup/treatment started in the same amount of time. So it is a game of utilizing your time & skills appropriately.
Where I'm doing my residency now, we pretty much do every procedure under the sun ourselves. We don't run Trauma per say, but there's always an EM Resident on the Trauma team, and the resident working in the ED runs airway. If Trauma hasn't arrived, we'll run it until they arrive. If it's really busy (multiple traumas at once), we'll run some and they'll run some.
Another thing to think about is, with many (not all...that's my disclaimer) of these large academic programs, you have 1001 fellowships. In turn, you'll have the fellows swooping down to steal many procedures from ya. Which again is why I love my program. Huge community program with full residencies, but only 3 fellowships - and none of them interfere with your procedural/educational experience.
Lastly (as already mentioned by previous posters) is your acuity level. Our acuity level is VERY high; we admit 30% of our patients. Ppl are sick as heck when they come in to our ED. Vs. say some EDs I've been to where a croupy kid was a Level 1 haha (a Level 1 for us is a cardiac arrest, impending resp failure req. intubation, or a STEMI).
Something to think about.