In my opinion, there is no dream pipeline. The software is selected to perform certain tasks. Which one depends on the budget and personal habits of the designer/studio.
There is a choice for almost all types of operations.
for installations: from Rigify in Blender to Ziva VFX in Maya,
for texturing: from ArmorPaint to MARI,
for modeling: from Blender to MODO (for example).
In addition, there are a huge number of CPU/GPU engines for rendering, paid and free. From Cycles and Bella to Redshift and Maxwell, etc.
In general, there is nothing much to discuss.