Agreed, especially for Google Takeout archives.
I actually tried the two most popular archive streaming solutions available to Node, and they were both surprisingly slow.
I found ratarmount a short while ago, and it’s the bee’s knees. Here’s an example that mounts 78 .tgz files into a single FUSE bind mount that PhotoStructure can then import from:
https://github.com/mxmlnkn/ratarmount/issues/45#issuecomment-748500218
Note that this support was just added by the author, so you need to follow the installation instructions in that thread.
Until PhotoStructure implements something similar to what ratarmount is doing, I think this is the best solution.
Would you want to use PhotoStructure to view manga? I suspect the files may not have sufficient metadata for them to be ordered correctly (unless it’s specified within the cbz).