Linux can support these workflows, but the experience is less uniform. Sandboxing can restrict access to external drives. Applications sometimes disagree on where data should live. Symlinks, bind ...
If you need to expand your Mac storage in a big way without breaking the bank, your best bet is with external hard drives.