Any typical analytics use case, where a single dataset (think a single table) is less than 2TB and the total data size is less than 10-20 TB in the organization. If that's you, you very likely don't need Snowflake and definitely not Databricks. An RDBMS would suffice, I recommend Postgres.
These sizes are just my thumb rules. Your mileage may vary.
I have people in my network use Snowflake with a total data size of 50GB!!! It makes my blood boil.