I have used Mode Enterprise for around one year, then we disconnected because I thought the price was high.
My main use case for Mode Enterprise was writing SQL queries and finding solutions, similar to what Snowflake does.
We used to write alerts and queries for finding missing data with Mode Enterprise. We also used it for visualization with an enterprise level license, which allowed us to utilize visualization extensively. That visualization helped us to analyze the data using SQL queries. Later we moved that functionality to Snowflake.