There’s nothing inherently wrong with Snowflake. But like any database it has a time and place.
For OLTP it would be unambiguously bad (although maybe there's hope with Unistore, which I haven't tried.)
Many workloads are a mix and so it can become ambiguous whether it's a great fit / great value / whatever you're defining good/bad-ness by
The Marketplace, Streamlit, and Native Apps stand out as particularly cool/useful.
More than anything, just the completeness of the platform (ie. data quality tools, governance, etc.) is super helpful to not have to cobble together.
The AI features they announced today also seem game-changing.
Of course, full diclosure, they are my lead investor but I chose to work with them for these reasons.