Which Data Lakehouse platform or product would be better for the Data hub Architecture implementation? Looking forward to the comparative analysis of the key vendors, especially the MS Fabric (OneLake), IBM (WatsonX stack), SAP (if they have this capability)?  Any thoughts or recommendations, based on your Org experience would be appreciated.

I think you must consider Databricks Lakehouse, MS Fabric and Snowflake Lakehouse Architectures.  With the recent advancements in storage and compute technologies, Lakehouse is a destination to be. The recommendations highly depends on the use cases problem you are trying to solve at your organization.  Which problem has a higher priority to be solved! 

We are implementing a DataLakeHouse with AWS technologies, including S3 storage and Redshift for Cloud data warehouse.  Redshift Spectrum brings the ability to query S3, making it closer to a DataLakeHouse architecture.  We are moving to cloud-native for DA technologies, so we didn't consider on-prem solutions.