hmm, I do agree, about letting everyone know what a prod. env. is actually like, but someplace, pipelines and workflows are actually covered under NDAs. Strange I know.
Anyway, some of the places I have worked have had teams for just modeling, texturing, etc, while others, you are assinged a shot and you do EVERYTHING. While others, I personnally did everything from concept art to output on characters.
Where I am at now, the nameless one, we have teams broken up for matte painting, creatures, modelings, enviro, comp, etc.
I know a few friends in LA are at shops where they get a shot, and do everything from building the new models for it, to texturing, animating and comping the results together.
Overall, I think the 2 biggest things people should realise:
Post prod. is your friend.
there is no harm in using more than one application. Model in what you like and has a good interface for you, animate in what provides you with the best tools, texture/shade/render in what you like and know, and composite the end results, dont be afraid to break up a shot and do multiple passes.
oh yeah, forgot this: