For your next sync
not so imaginary after all
I get it you are frustrated but Manjaro Linux is not at fault here.
What you can do
Use a live Manjaro ISO to boot the system. If you don’t have one - either download an official ISO or a dedicated Manjaro Rescue ISO from https://manjaro.dk/iso/
Open a terminal and change root to the system on disk.
Assuming a default installation on nvme using EFI and btrfs, first mount the subvols
mount -t btrfs -o subvol=@ /dev/nvme0n1p2 /mnt
mount -t btrfs -o subvol=@cache /dev/nvme0n1p2 /mnt/var/cache
mount -t btrfs -o subvol=@log /dev/nvme0n1p2 /mnt/var/log
mount -t btrfs -o subvol=@home /dev/nvme0n1p2 /mnt/home
mount -t vfat /dev/nvme0n1p1 /mnt/boot/efi
Some operations requires to mount hardware related filesystems as well
mount --bind /dev /mnt/dev
mount -t proc proc /mnt/proc
mount -t sysfs sysfs /mnt/sys
mount -t efivarfs efivarfs /mnt/sys/firmware/efi/efivars
Create the chroot environment and use bash as shell
chroot /mnt /bin/bash
Inside chroot
Create a list of alien packages
pacman -Qqem > /alien-package-list.txt
Unconditionally remove all aliens
pacman -Rdd < (pacman -Qqem)
Then run a full system sync
pacman -Syu
Exit chroot and reboot the system
System restored
Evaluate the content of the alien-package-list.txt and rebuild only those required for your day-to-day operation.