I have heard exactly opposite argument. When I automated a process which used to consume hours, vp said this is good but I will prefer to buy a product because inhouse automation creates dependency on individuals. He was right because after hearing this I left within a months.

Years later they are still using my dirty scripts :)