I have 2x of the ASRock R9700. The PC lives at my desk as well. I’ll ramble my thoughts below.
At full power and full load, I find them to be disruptively loud. They are not high-pitched and annoying, so if you wear nice isolating headphones, you might not really be bothered. My headphones don’t have much isolation (and I’m often not wearing headphones) so I’m not keen to run them at full tilt. YMMV there.
That being said, I reduce the power in the Adrenaline software by -30%, and then they’re pretty quiet even under full load together. The way I use them is not especially sensitive to time/throughput/raw performance so this is fine for me; I honestly haven’t even benchmarked to see what the performance difference is, the noise (and power/heat) reduction is way more impactful than any tok/s in my case.
Can’t comment on different vendors - I have a local Micro Center and was able to get them open box, so they were simply the best deal by far ($1110 before tax). For me personally, it has been a long time since I’ve used any high-wattage blower cards so it’s hard to compare. I was expecting a blower at 300W to be loud so this wasn’t shocking (and I doubt any of the other vendors would manage to be much quieter, but don’t take my word for it).
Still, I was very pleasantly surprised by 1) how they are much more wooshy than whiny, that’s a big plus and 2) how much quieter they are with power tuning. You can probably be a lot less aggressive than -30% and still tamp the noise down considerably.
Without any tuning, they are (each) definitely louder and more disruptive than my 5090 at full load, but maybe less annoying than my older EVGA 3080Ti at full load (because the latter has much more of a “whine” to it). With tuning, if I’m not wearing headphones, I can tell they’re working, but they easily fade into background noise. When the A/C is running I can’t hear the PC at all. So, there’s a wide gulf to play around in between “barely notice” and “too loud” (for me at least).
TL;DR: Stock behavior on an ASRock model is probably not well suited for an otherwise quiet environment, but headphones with good isolation may help a lot. That said, there’s a lot of wiggle room in power tuning and undervolting. I run a set-and-forget -30% power limit with no bells or whistles and then they’re barely noticeable, so I imagine there’s a lot of room to find your sweet spot.