I have a Zyxel NAS server that just offers a SMB share. I'm just dumping my photos there under YYYY/MM/DD scheme, and converting all of my Nikon NEF files to DNG. (For importing photos to the NAS and generating backups, I have a PowerShell script and a PowerAutomate action. Also mild usage of Dropbox to transfer files from my cellphone.)
For actual management of photos, I use ACDSee Photo Studio Professional, and it just writes all tag information to the files themselves, so I can basically use any other software for photo management. For actual photo editing, I use DXO PhotoLab and Affinity Photo most of the time.