TIL that there's a utility called kio-fuse which just completely solves the "cannot open files from remote filesystems without copying first in KDE" issue on #NixOS
This post explains how it works: https://forum.endeavouros.com/t/fixed-please-include-kio-fuse-in-the-kde-desktop-metapackage/11437/17