Photos will never reach the level of sophistication that Aperture had, it's just not designed for the pro or serious hobbyist use. Again, you don't replace an $80 app with a free one.
Among the non-subscription options:
Photo Supreme
NeoFinder
OneOne Photo Raw
CaptureOne (which has both a buy outright and a subscription model)
These are some that have reasonable quality DAM features. Photo Supreme is actually only a DAM.
On a small note: the makers of Luminar have a track record in over-promising features and not quite delivering. I'd test that the app is good for your usage thoroughly before upgrading to v4 which is due soon. In fact, you might find that the level of updating required to stay up-to-date with an app like Luminar is remarkably similar to paying a subscription.
Also, it is worth noting - and this is commonly misunderstood - that if you stop paying your subscription to Lightroom, the Library part - the organisation bit - continues working. All that happens is you can no longer use the app to edit photos, and I believe the map section no longer works - but the rest works fine. Just saying.