What’s the best way to handle leftover files from uninstalled apps?

Over the years of downloading, using, then potentially uninstalling apps I’m sure a lot of apps leave behind files that are no longer needed and are just taking up space. What’s the best way to find these files and remove them? I believe the storage display in system settings only displays the size of app bundles and doesn’t account for support files, and deleting apps using this is sure to leave files behind. I’ve heard that apps like CleanMyMac give pretty bad performance hits and use shady and exaggerated marketing. Are there any powerful alternatives? I wish there was a solution (built into macOS or otherwise) that could keep track of files that apps download and can provide a way of cleaning absolutely everything an app used when you delete it.