Will a hole in the top of the radiator well cause a 1986 camaro to over heat?

Yes. This will cause the water to leak out under pressure and cause overheating. A hole like this should be repaired before driving too far in this vehicle.