> transcode...

I guess other important point is to store originals as well (or maybe even rendering originals directly). and also RAW format for audio video.

then comes question on handling 250GB+ videos and libraries for TBs sizes

Apple Photos rocks in all of the above. and it also works excellently offline.

to beat it you have to really solve those problems..