Looking for the best nas solution

[ed]

Yes, Thunderbolt solution for local use will be a logical choice. There are only 72XT and 88X series that allows this connection
https://www.qnap.com/en-us/product/?conditions=2-8
https://www.qnap.com/en-us/product/?conditions=2-13

You can then set up QSYNC that can be used for cloud collaboration - shared timelines.
Otherwise, you can also use 10GbE or 25GbE connections to elaborately edit.


I hope this helps.