So we do a kind of combination of yours and Kevin's approach. The report that is actually emailed is for the whole department (I love me a good shame email 😉 ), but in that report we have a custom message that says something like "If you'd like to see just your projects that are out of compliance, please visit..." and then re have a link to another report that uses the wildcard $$USER.ID.
So if they are a manager (or nosy), they can open the PDF and see everyone in trouble, or they can click the link and see just their projects.
If you have the ability to vote in the Innovation Lab, I highly recommend upvoting this one: https://one.workfront.com/s/idea/0870z000000PSLxAAO/detail 😎