Can you explain more about the source of the photos you are managing and your issue with the Photos app?
For photos taken with iOS devices, my opinion is, use the Photos app, anything else is swimming against the current.
For photos taken with other devices, you may want to keep the originals in your own organized folders and access those with Lightroom, and then possibly put favorites into Photos.
There’s a Photos Library manager app that may help you get rid of duplicates: PowerPhotos – Merge Mac Photos libraries, find duplicates, and more
And, there’s a famous Mac blogger and podcaster who wrote a Field Guide on the subject 