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
Human error is the biggest factor.
You edit a file, do you directly copy it over? Probably not, so when is it time to copy over? Maybe you remember maybe you don’t.
Ohh you Deleted a File? Did you delete it on the other one aswell? No, well now we get into the rabbit hole of dependencies.
Sure you may be able to automate it via Rsync. But how often? once a day? once a month? what happens if a Drive writes faulty data and does not tell you? Well now you copied it over in the hopes it is not broken.
You want to retrive a file because you accidentially deleted it, well that file has been sitting there a long time, its corrupted now. But it has never told you it is and you have no redundancy to correct errors.
Theres many more reasons just copying it is not a good Idea those are just some examples. Theres also Raid soulutions to accommodate mixed drive sizes like Unraid does. And yes it costs money but with Snapraid and Merger FS you can do the same thing for free.
Sure it maybe more effort but the question should be how much is your data worth and are you able to lose it? And what does it cost you to get it back again.