Expose RequestOptions for methods causing noisy logs/tracing

[lmolkova]

Replacing the original issue #25626

The upcoming Azure.RequestOptions gives us the chance to expose ErrorOptions from our convenience methods. We're not planning to do this everywhere, but there have been a handful of cases where the noise of an expected exception degraded the observability/diagnosability experience for customers. This was discussed in detail in the ArchBoard meetings at Azure/azure-sdk#3391. This work item tracks enabling the first set of experiences for HLC libraries.

Foundational

• Add RequestOptions - [LLC] Move RequestOptions into Core autorest.csharp#1666
• Support RequestOptions via the AutoRest's HLC generator - Enable select HLC methods to use RequestOptions autorest.csharp#1734

Use internally for both sync/async overloads:

• (Azure.Storage.Blobs) Blob Download - [Feature Request] Consider allowing the ability to opt-out of distributed tracing for expected HTTP error responses #9934
• (Azure.Storage.Blobs) Blob Exists - [BUG] BlobBaseClient.Exists always logs exceptions to App Insights when the blob does not exist. #18592

Expose publicly both sync/async overloads:

• (Microsoft.Azure.WebJobs.Extensions.Storage) Receipt Manager - [BUG] Lease already present after upgrading to Microsoft.Azure.WebJobs.Extensions.Storage 5.0.0-beta.3 #21511

Could either expose publicly or add an If(Not)Exists method to use internally for both sync/async overloads:

• (Azure.Search.Documents) Get Document - [FEATURE REQ] Consider a GetDocumentIfExists method for Search #17445
• (Azure.Security.KeyVault.*) Delete - Delete throws error if secret doesn't exist #25125
• (Azure.Data.Tables) CreateIfNotExists, CreateTableIfNotExists, GetEntitiy - [TABLES] GetEntity/Async should not throw exception on 404 #16251
• (Azure.Data.AppConfiguration) Create - [FEATURE REQ] AppConfiguration ConfigurationClient is missing CreateIfNotExists API #14802 (comment)

[github-actions]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @xgithubtriage.