Here is a report that one of our engineers made. He pulled the info from ConnectSecure via CSV, used Python to review the data and save the metrics to a JSON, load the report in HTML, and print the results into a PDF. It is a little rough around the edges, but I believe your team would be able to create a polished version of it.
It would be helpful to have a report for internal vulnerabilities and a report for external vulnerabilities that includes the following:
-Total count per severity
-Trend information
-Average Age
-EPSS Distribution by Severity
-Age Distribution by Severity (with trending data)
I tried playing around with the AI reports but was not able to reproduce this on the same level.