Snowflake is by far the best data warehouse I have ever used. I would use it at any job where data warehousing was a keystone of our work. Really 10/10, not even close.
Because I had the opposite experience - you literally couldn't pay me to use Snowflake again.