86W so about 20Euro/Month

Not to be rude or anything, but External RAIDs individual to the user is not really a solid soulution. It may work for 1-2 People working on one project at a time. But it just does not scale. What if someone needs to acces files of that project? they move the raid or plug their laptop on a differen workspace? Not really a great soulution IMO.

Like you say in the last part having a NAS with maybe a bit of room to grow sso 100TB might be the best option that way everyone can access the data and work accross projects. And more importantly it would offer work from a different place in the office or even work from home.

Yea with tape the compressed nr are very missleading. Thats a best case scenario where the files compress 2:1 with TAR+gzip which it literallly never does. Bestcase I have seen was 1.2:1 on a folder consisting of config files. Basically nothing nowdays is compressable you will interact with, except textfiles depending on format. So its best to always asume the raw space as the space you get

From what it sounds you want a NAS and Tape Archive.

So get a device which holds your working Projects, you mentioned arount 20-40TB which is no problem nowdays. Can be done for under 1k with of the shelf stuff.

And Tape backup for stuff you dont need regularly. Maybe chose an older generation of LTO I would look for something that can hold about 1 Project per Tape or the likes of it. LTO5 is pretty cheap used, ca be had for 500 Bucks but is only 1.5TB per tape.

Disclaimer, with LTO never look at the compressed NR, its for compressable data only which video is not. Thus with LTO9 you will only get 18TB

Well ddns is just dns which get auto updated via helper script which you can do yourself on your own domain aswell. So yes Point still stands. And a domain which is yours might still be nicer than a bottom of the barrle subdomain. Of which you often also don’t get unlimited

Yes, because how will you acces wireguard? Whats your endpoint?

I mean its all fine if you have a static IP which never changes but that usually is not the case anymore. So you need a domainname to update. Also vpn.youlab.tld is esier to remember than 131.234.142.83

WIth any kind of advanced software you will never be getting drive speed out of a soulution.

Raw nvmes can hit 800k iops. Add XFS and you may be able to get that.

with MDADM you get like 200-300k

ZFS shrink it to 20-50k

Anything network be glad if you get 5-20k

The more software is involved the worse performance gets especially for IO. Sequentials often scale better or even linearly, but IO is a PITA