Earlier quoted context omitted.
Keep in mind that you'll only find results from people who have issues. Few people will go online just to say their hardware works with Linux. To give a concrete recommendation for a wifi adapter, look at Intel-based hardware. Intel stuff generally works out of the box because they contribute drivers to the Linux kernel directly. The ASUS PCe-AXE58BT is based on Intel's AX200 so should work out of the box on any mode…
The Asus card isn't available in my region. I can find TPLink Archer TXE75E V2 which seems similar (BT5.2, 6E) - I can't find any info on linux support or BT.
It's the chipset that you would need to ensure compatibility with, unfortunately I can't find anything concrete on the actual chipset used, Intel only has 3 wifi 6E chipsets and as far as I can tell (from here https://venzux.com/intel-ax411-vs-ax211-vs-ax210-wi-fi-6e-mo...) they should all be compatible with Linux.