How do they affect a colony?
They don't have any positive benefit at all to a colony. In fact, they can mess with your colony's approval by bringing unemployment and other complaints.
That is why it is a good idea to turn off your stargates when you are not in need of any immigration.