I used QUERY_ALL_PACKAGES among other things for my app Limit Buddy (https://www.limitbuddy.com). It would be impossible to make the app without it. But for more normal use cases there's no reason to have it.
Apple has a much more robust solution privacy wise with their ScreenTime API but it makes an app like Limit Buddy much harder to build.