Upgrade to macOS Ventura if your Mac is compatible with it. The Photos app on macOS Ventura includes a duplicate detection feature that can automatically identify duplicate photos and move them to the Duplicates album in the left sidebar.
You can find more details in this article: Fix Ventura Photos Duplicates Not Showing & Remove Duplicate Photos
However, if your Mac doesn't support macOS Ventura, you'll need a third-party duplicate photo cleaner. I recommend you try iBoysoft MagicMenu if you want to right-click on a folder to find and remove the duplicate photos inside it.
After the search process is complete, this tool will automatically select the duplicate photos and display the original copy alongside them for you to check. You can deselect the photos you want to keep and browse the duplicates based on the creation dates.
It also shows you the number of selected photos and the space you can free up.
Click the button below to try it out! (Supports Intel, T2, M1, and M2 Macs running macOS High Sierra and later)