There isn't a "best" one because it depends on exactly what your requirements are.
Photos is not as good as Aperture as a DAM. but it can be its equal as an editor, using extensions that allow you to link to other apps. It's free. But it is, frankly, a consumer product. If you're a pro or serious hobbyist, if you're shooting Raw with a DSLR then I would suggest you look elsewhere.
Most people ended up with Lightroom Classic (as it's now called). It's a very good app, very powerful DAM and very good editing tools. It links effortlessly with Photoshop, unsurprisingly. It's also an excellent host for plug-ins like the Nik package, or can use some stand-alone apps, like Luminar or Exposure X5 as plug-ins. It can pass Raws to other raw developers like DxO PhotoLab. It really is a very good hub for your workflow. Downside? Some folks don't like the subscription model and that's now the only way you can get it. But it is very good value given that you also get Photoshop in the same subscription.
CaptureOne is probably the second most popular destination. An excellent raw developer, some folks are unhappy with its DAM. There's a bit more of a learning curve too (or that might just be me ;) ), and it is expensive. But it can be bought outright, or subscribed as you prefer.
Mylio is an excellent app that, capability wise is more powerful than iPhoto but not quite up to Aperture. But it is an excellent DAM, and if your goal is sharing across devices they're ahead of almost everybody.
PhotoSupreme is just a DAM, and quite a good one. But you'll need something else to process the photos.
Luminar is a well-marketed editor. I'm more impressed with the marketing than the editor. Exposure X5 has a rapidly developing DAM and is almost as capable as LR in many respects. It's well worth checking out.
OnOnePhoto Raw pitches itself somewhere between LR and Photoshop. It has elements of both. Bit of a chequered past, but the current version is positively received, like they may have reach a level that makes them a real player in the field.
DxO Photolab is a very good raw developer, probably the best for noise reduction and arguably, on a par with CaptureOne. It doesn't really have a DAM, or at most a very rudimentary one.
There's a few worth looking at. One thing about photography apps is there there are a multitude of review sites and photography blogs that will tell you a lot more about these apps. Youtube is especially worth looking at as there are thousands of posts there with folks reviewing, doing hot-to and the like.