We are currently working on the development of a National Data Repository Analytics Workspace for Nigeria. During the choice of a BI tool, I recommended Apache Superset over Power BI but those used to Power BI kicked against it. I led the team that built the analytic Workspace that will be launched sometime in August of this year.
From my above intro, I will first of all recommend you know what you want the BI tool to do for you and that will lead to a better recommendation. As for me, I have not worked with Metabase but have worked with Apache Superset which has all the features you mentioned. It allows drill down, drag and drop, customizable charts, customizable UI/UX, performing some SQL analytics, etc. We have just upgraded to the latest Apache Superset version with enormous features. The community is wonder in terms of support, the Slack also provides supports within the shortest time.