It’s possible to include your NAS and Google Drive in the files app which should give you what you want.
https://www.techrepublic.com/article/how-to-use-the-files-ap...
I use iCloud to do exactly what you say and trash the physical copies, but it should be possible with anything in the files app AFAIK.