Some data points on W series based on direct experience:
I found W5700 worked well under Big Sur and Monterey most versions, iMac20,2 and iMacPro1,1.
There was a benchmark performance slowdown that required some renames in WEG after a Monterey point update, but this slowdown went away with the next point update.
I could've guessed the W5000 series cards are solid choices, except they were, and remain, expensive, and my W5700 just died without warning last month—got it new a year before.
Replaced with a MSI Mech RX6600XT (also dual slot but shorter). Mech is 30% faster than W5700, at 1/3 the price! But as EdHawk notes, 6600s req Monterey 12.1+
I was concerned about thermals due to RX6600XT venting inside case with super hot overclocked 11th gen running allcore transcodes, but it hasn't been a problem so far, as I don't run the GPU hard and its fans stay off more than the half the time. It's a zero RPM card.