I tried. I really trief to get away from any dependency and host on my own. I have more than 8T of photos, not to mention much more of TB in video. I do not really organise my videos but they all have geo tags, text tags, etc. I heavily rely on face and object recognition and have a timeline of 15+ yrs. I tried to move from Google Photos and Apple Photos (I sync and use both in parallel) to an opensource solution like NC with facial recognition or immich.

Following issues I encountered:
* Browsing the photo gallery in general is even on mid-sized hosted servers (ryzon epic 4th gen with 32gb+ ram slow)
* Mobile App of NC does not provide solutions to filter for faces/objects
* I tend to use "Babe + red dress + beach + high heels" or "mercedes + Zurich + summer" as search terms which do not provide me what I what expect
* indexing the initial data takes long time (in the previous mentioned areas we don't speak about day or weeks, we speak about months!)
* NC requires so much more around to run well in general (caching!! Did I already mention caching?)

Currently, I think, Immich the better way to go which also lacks several problems but got at least working mobile apps.

sorry, just my 2 cents from someone who's looking to migrate 20+ TB of data into any suitable opensource solution and always failed.