Although it might reveal a different concern than data higiene, another query I would suggest - mostly for old Salesforce orgs with email-to-case - is:
SELECT FromAddress, COUNT( Id )
FROM EmailMessage
GROUP BY FromAddress
ORDER BY COUNT( Id ) DESC
LIMIT 100
There are a bunch of other queries I have for old email-to-case orgs.