when should you actually think about a data lakehouse

hey folks, ive been seeing a lot of buzz around data lakehouses lately. were currently managing a pretty complex data warehouse setup and starting to feel some pain points with scaling and flexibility. before we dive deeper into evaluating specific vendors or building something ourselves, im curious about when this architecture really starts to make sense. what are the key indicators or specific use cases where a lakehouse architecture offers a clear advantage over a traditional dwh or even just a data lake with a robust query engine on top. any real-world experiences or gut feelings appreciated