Welcome to the forum.
Please carefully follow the suggestions on this Alfred help page and see if any help: Troubleshooting File Indexing Issues.
If you then still have problems drop a problem file into the built-in troubleshooter (follow the instructions on that linked page) and post the complete output in another post here.
Please also tell us when your "recent” problems started and what changes you had made on your Mac around that time.
Stephen
macOS is simply working as designed—copy is what it does when you try to move a file from an internal to an external drive. See this post, for example.
Stephen
Make sure (double click on the Copy to Clipboard action) that you have checked Automatically paste to fronmost app. However, the immediately obvious problem is that you appear not to have linked the Dispatch Key Combo correctly. It need to be properly linked to the Copy to Clipboard action (because you want the tab to be the last thing that happens).
It may be helpful to take a look at this Alfred help page: Getting Started with Alfred Workflows—as well as this page which is helpful in explaining how to connect objects in a workflow.
Stephen
Welcome to the forum. Please take a look at this post about how to report problems with workflows and post the outpout of the debugger when the workflow is run.
Stephen
I suggest you follow the Troubleshooting File Indexing Issues suggestions and if those do not resolve the issue drop the 1Password app into the troubleshooting pane (as described on the help page) and post the results here.
Stephen
Take a look at this recent thread. You could, in the case of either suggested solution, add a Dispatch Key Combo Output to the workflow to add the tab.
Stephen
One way of doing it would be to create a short workflow. Start with a Keyword Input with no argument. That would be effectively the Snippet keyword you would wish to expand. Connect that to a Run Script Action which contains the command line script and then connect that in turn to a Copy to Clipboard action—checking the box to automatically paste the frontmost app.
Stephen
With apologies for the self-promotion, you could take a look at my Photo Keyword Search worklfow (the link is to the relevant forum thread). I suspect that could quite easily be simplifed and adapted for what you need…but it would involve some work!
Stephen
Purely as a matter of interest at this stage:
are your photo files RAW files, JPEGs or some other format (and, if so, what);
do you use embedded metadata or sidecar .xmp files?
Stephen
Only in so far as use of the migration assistant frequently seems to cause problems with various apps (as I, too, have experienced).
Try granting Alfred the permissions he needs. If that still doesn't work you could try resetting the permissions.
Stephen