Since I trained at both of these places and practice at one (thanks for calling me a god, by the way), I have to respectfully disagree. I think it would be hard to spend time at either place and still have that opinion, but maybe that's the reputation that floats around.
At the U of C, I rotated through the MICU (pulmonary run, mostly) and the CT ICU (anesthesia), totaling 6 months and in both, the service was largely resident run. The MICU had fellows which, to me, seemed mostly invisible. The attending rounded in the AM and then disappeared. I was always very impressed by how effective and autonomous the residents were (in retrospect, maybe this was bad for patient safety, although the residents were very strong).
At UCSF, I think the resident experience is diluted a bit, but not for the reason you cited. Because it's largely a consultative service, there is less autonomy for decision-making, which I think reduces the educational benefit. That said, at least the medicine residents see the ICU from both sides (as the ICU consultant and, at other times, as the primary admitting floor team), which probably has some benefits. I can't speak for all the other attendings, although I worked with nearly all of them as a fellow, but I/we/they are only dogmatic about a very few things:
ARDSNet
"quality" (quotes deliberate, and beyond the scope of this conversation).
My opinion, based on the experiences listed above, would be to go to the "best" program you can, whatever that means to you, recognizing that your goal should be getting you to whatever comes next. Unless humping cases at a small, community hospital is what you want to come next, going to a small community hospital for training might unnecessarily limit your option.
My guess is that both Yale and the U of C would open similar doors and would train you well for either academics or PP.