Hi Vero,
Sorry for the late feedback on my issue.
The good news is that after trying multiple things, I got Alfred back working ... 😉
Maybe I was not looking in the right place, but I could not find a way to create the File Troubleshooting checks.
So I could not initiate them (any link to the where I can find them ?).
I think the issue was related to the fact that when restoring Ventura, I was asked what to do with the existing user.
Since I had full Time Machine backup, I asked to delete the existing users.
My account was well restored, but then Alfred did not find my (newly restored) iCloud Drive.
My best guess is that some how, there were still references to the "old" deleted user,
so Alfred was still looking to the "old" user's iCloud Drive, which was emptied.
After completely deleting the "old" user from my system and a new indexation of Spotlight,
Alfred also found the iCloud Drive. 😉
Thank you for reaching out, if I you need any further information, please let me know.
Best Regards
Francis