add_cloud_metadata: add debug logs for attempt start and failures with the name of the provider

[lucabelluccini]

Describe the enhancement:

Right now, it is not very transparent looking at the logs when the add cloud metadata collection starts and ends (regardless if it is successful or times out).

Describe a specific use case for the enhancement or feature:

Troubleshooting issues related to add_cloud_metadata.

[botelastic]

This issue doesn't have a Team:<team> label.