Are there analytics packages for AEM (not talking about Adobe Analytics)?

Hi,

We have Adobe Analytics and a Redshift instance where we put our web metrics, Qualtrics surveys, content inventories, etc. 

But we get constant requests for insights on what's going on inside of AEM. 

1. List of pages with a specific value in a tag list. Can we get a list of pages that have “Payroll” in the product list tag?
2. List of pages that have specific terms in the text. Can we get a list of all pages that contain the phrase “packaged solution” or “marketplace packaged solution”?
3. List of pages with specific components. Can we get a list of pages that contain dynamic components?
4. List of pages created by or modified by a person or list of persons.The following authors have left the company, and their content must be re-assigned to new authors. Provide a list of pages that have been authored by or last-modified the following people: Name1, Name2, …
5. List of pages that contain a specific type of asset. Can we get a list of all pages that have attached Excel spreadsheets (.xlsx)?
6. List of filenames for assets that have been updated over time. Can we get a list of all filenames for each asset identifier, so that we can track downloads of the asset over time, regardless of the versions? We have the filenames/URLs from Adobe Analytics.

The list goes on.

I feel like there must be ways to do this within AEM itself, so our authors can run reports to better manage our data.

Do reporting packages exist for AEM that can do this type work?

Thanks for any suggestions!
Curtis