Just to update this thread for the benefit of other.
I had exactly this noise,
I ended up using a syringe and needle to insert grease in the lower ball joint through the rubber.
Obviously this is not a permanent fix but at least now the car is quieter until I get the balljoint changed.