Usually adding one new resource subtracts a resource overall because they take other resources time. In the best case it may give you half a resource boost but it puts pressure on supporting units.

Especially if you only think of them as ‘units’ rather than individuals with strengths and weaknesses.

It doesn't.

Not if you want it doing on time, budget or to any degree of quality.

You get more bricks but a worse wall.