3. the fonts used by my colleagues (Windows) only worked partially (Calibri was displayed pixelated)
4. the complex Excel spreadsheets we used could not be used in Libreoffice (error)
...
6. last but not least the biggest problem: Indesign.
In switching away from Windows, Excel compatibility (and for you InDesign) was a big concern for me. The MS Office webapps just don't cut it (even ignoring performance or feature differences between browsers) and the Linux alternatives are... lacklustre, to put it mildly. I don't want to sound ungrateful for the herculean efforts put into developing open source office software with MS Office compatibility, but I will say that they still have a long way to go.
I moved away from Zorin for other reasons, but something I have now settled on with my current distro is using KVM / QEMU + virt-manager to run a Windows 10 Pro virtual machine specifically for Excel. The process was incredibly easy as my distro already had KVM installed so I just added virt-manager, used my old Windows laptop to grab a new ISO from the official Media Creation Tool, booted a new VM container, and it just installed with no issues. YMMV. I gave it a 32GB disk and it consistently has 5GB to 6GB "free" with just Office 2021 as the only additional thing I've installed.
I will note that that I don't think virt-manager / KVM currently have a method to easily setup shared folders between the host and guest, you will have to create a Samba share on your host OS and add that as a network drive in the Windows guest. You can, however, copy-paste files (and generally share the clipboard) between a Linux host and Windows guest very easily - just install the Spice guest tools in the Windows VM, reboot it, and you're good to go. I also manually set the CPU configuration / mapping, but that's just me being pedantic and not at all necessary for most users.
I am using a legitimate product key I already owned to activate the Windows 10 Pro running in the VM, but it is possible and legal (check your region to make sure) to buy them cheap from certain online resellers / marketplaces and there are other options for activation as well. Technically you don't need to activate Windows, I think, it just drastically limits customisation settings and probably limits Windows Updates as well.
Anything you need that doesn't run at all, or not reliably enough, on Linux can be installed in the VM, which you only launch as-and-when you need it. Way more convenient that dual-booting, and also more secure as the guest OS can't access the host directly.