A quick update on my experience so far with the ASUS 2090 TUF OC.
Firstly, it's a nice looking card (as far as PC graphic cards go). Definitely not in the same league as Nvidia's FE, but nice considering it fits beautifully in the case. Really impressed with the build quality. The small RGB light on the card looks like a beating heart inside the Mac Pro, which is kinda cool. I was planning to disable it (if that's possible), but I kinda like it.
Based on Alex's experience, I opted for Slot 3 - directly above my AMD Radeon Pro Vega II. I chose this slot to avoid the card sag Alex mentioned when installed in Slot 4. This is a pretty heavy card.
Here's the cool part. I added two small spongey sticky circles to the end (at both edges) furthest from the board connector. They were part of a velcro sticky set I purchased a while ago. I used two soft circles. This is to avoid any sag from the card damaging the top of the Radeon card.
As Alex mentioned, there's no real difference in card temperatures between Slot 3 and Slot 4, so I think it makes sense to install the card in Slot 3.
I'm using a temporary Moshi USB-C to DisplayPort Cable (from the Apple Store) while I wait on my Belkin Charge and Sync Cable (for Huawei VR Glass) being delivered from China, which should enable brightness controls in Windows Boot Camp. The Moshi cable works fine for now.
Finally Cyberpunk 2077 runs spectacularly well using Digital Foundry's recommended settings (for 4K) via
Mind-boggling stuff. I'm running these settings along with a V-sync at 60 (to avoid tearing) and it's buttery smooth.
Stock noise levels are acceptable. Pretty much what Alex mentioned in his post. I have the card set to performance mode. Sure, the Mac Pro fans kick on a little during play, but it's not annoying. I'm going to tinker with undervoltage settings this weekend and I'll report back then. I'm hoping to get the same results as Alex. Fast but silent.
It's worth mentioning that I'm running a 16-core 3.2GHz 2019 Mac Pro with 192GB RAM.
Oh, and the card is completely silent when running macOS.