In a nutshell
Qualcomm: better support for amd, no support for linux
Intel: support for linux
Other than that it is too early to tell because drivers continue to be developed and it's still early days for wifi 7
Intel usually has two type of WiFi adapters. One tries on things in their CPUs, the other one doesn't. So it a bit strange that this video finds it surprising that there's a version tied to Intel CPUs. I'd always get the one that doesn't need an Intel CPU. This as it'll impact your CPU less,, Intel or not.
Some Qualcomm adapters do work with Linux, those that were available last year. The MSI does not seem to work with anything else than Windows 11 at the moment.