You can consider data warehouses when you need quick responses to ad hoc queries. Let's consider two scenarios.
One, you have internal users who wish to query your data, and you want to minimise the time it takes for them to get an answer.
Two, these same internal users are okay with the data/metrics only being available/refreshed every few hours.
In the first case, you might want to use a data warehouse and in the second, job clusters. The former is optimised for quick reads and queries and the latter is generally more cost effective.
Furthermore, recent developments have Genie enabled on SQL Pro, enabling you to question your data in natural language, allowing less technical people to get their data-related questions answered more easily.
For better or worse, you need SQL Warehouse to run this for now.