Azure Datalake Storage V2 ObjectStoragePath connection issues

### Apache Airflow version 2.9.2 ### If "Other Airflow 2 version" selected, which one? _No response_ ### What happened? Connection parsing seems buggy with the Azure implementation for ObjectStoragePath - requiring specific extras in specific places that don't really make sense. This is also inconsistent with the `AzureDataLakeStorageV2Hook` connection parsing Additionally - there is no documentation at all about an Azure implementation for ObjectStoragePath - so we should make sure to have a doc associated with the provider. Furthermore, this is a Microsoft problem - but why there are [three solutions for the same thing, each with different terminology](https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-best-practices#understand-the-terms-used-in-documentation), in varying degrees of supported or deprecated - is wicked confusing. ### What you think should happen instead? _No response_ ### How to reproduce 1) ✅ `extras.connection_string` - works for both the Hook and Object Storage, without issue: ``` import os os.environ["AIRFLOW_CONN_ADLS"] = '{"conn_type": "adls", "extra": {"connection_string": "..."}}' from airflow.providers.microsoft.azure.fs.adls import get_fs from airflow.providers.microsoft.azure.hooks.data_lake import AzureDataLakeStorageV2Hook # Hook print(list(AzureDataLakeStorageV2Hook(adls_conn_id="ADLS").get_conn().list_file_systems())) # Object Storage get_fs("ADLS") ``` 2) ❌ `host`+`login`+`password`+`extras.tenant_id` - ✅ works for the Hook, ❌ DOES NOT WORK for Object Storage: ``` import os os.environ["AIRFLOW_CONN_ADLS"] = '{"conn_type": "adls", "host": "myfilesystem", "login": "...", "password": "...", "extra": {"tenant_id": "..."}}' from airflow.providers.microsoft.azure.fs.adls import get_fs from airflow.providers.microsoft.azure.hooks.data_lake import AzureDataLakeStorageV2Hook # Hook print(list(AzureDataLakeStorageV2Hook(adls_conn_id="ADLS").get_conn().list_file_systems())) # Object Storage get_fs("ADLS") # ValueError:…