My experience with this is it's more of a gimmick. It's cool when it works but most of the time I've found it simpler and more accurate to just select the data you want.
It does help with discovery if configured well. 'Configured well' is a fairly high cost, so only worthwhile for a fairly simple data model that will have a large number of consumers.
Typically, there's not much of a population of "people who are unfamiliar with the dataset, but need to ask questions of it".
I do agree. It can work and when you've put the time into designing it to work then it can feel fairly magical, but there's a point at which you feel like you're almost pre-creating all the queries for users.
