I'm also a semi-pro (technically I'm a pro but it's just a side gig) photographer who uses DxO. I really like DxO for color & exposure, as well as denoise, but I've gotten supremely frustrated at it's lack of more sophisticated editing functionality. I'm increasingly considering an Adobe subscription just to have something with more effective AI masking -- DxO stinks for this -- not to mention small things like generative fill to simplify stuff like powerline removal.
The amazing thing about Resolve is that the free version is almost certainly enough for > 95% of use cases. The features that are locked behind the Studio upgrade are truly pro features - in that you won’t need them at all unless you are delivering for a proper studio or professional project. The amount of firepower you get from the free version is easily at parity with any comparable product from Adobe/Apple - and in many cases blows them out of the water… for free.
IIRC, it only officially supports CentOS or some other baroque thing, doesn’t support importing or exporting mp4 when free, and also (unrelated to the product itself) Linux hw accel of video is flakey.