I enabled Query Store on a 3 TB sized database that is bulk loaded nightly. During the day it receives a fairly high volume of queries (ie: 100 per second) at a steady pace between 9am - 6pm from a call center application and also sporadic ad-hoc (sometimes overly complicated) queries from the BI and other data analysts throughout the day and into the evening. We do use SentryOne montitoring, which is great for a lot of things, but this tool is configured to only capture execution plan with a runtime > 10 seconds. For historical usage statistics on high volume sub-second execution plans, like the ones coming from the call center, I turn to Query Store.
I wouldn't say it's the greatest thing to ever happen to SQL Server, data management views and plan guides were introduced back in 2005, but persisting the dmv data to a more star-schema data model is a big step forward and a foundation for building better query analysis and optimization tools.
"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."