I always say to just get the one that gives you the best price because performance-wise, they're all within spitting distance of each other.
Twin-fan models are quite capable of keeping cool, it's just that their two fans have to spin faster to move the same amount of air as a triple-fan design. That creates a bit more noise that most people don't care about but some people hate. There's also a cost premium involved in most triple-fan cards and your case has to be large enough to accommodate them (this isn't usually a problem).
The best price on a triple-fan model would be one of three (and they're all Gigabyte). I don't know why Gigabyte has three triple-fan models with two that look almost identical but whatever.
These cards all cost ~$600 and all have three fans but one card is longer than the other two by almost 40mm. If you can fit it, that's the card I would choose if I were you.
Introducing, at 261mm, the Windforce:
Gigabyte GeForce RTX 4070 Super Windforce 12GB: $600 (Newegg)
Introducing, also at 261mm, the Eagle:
Gigabyte GeForce RTX 4070 Super Eagle 12GB: $600 (Newegg)
Introducing, at a whopping 300mm, the Gaming OC:
Gigabyte GeForce RTX 4070 Super Gaming OC 12GB: $599 (B&H)
As I said, if you can fit it, the Gaming OC would definitely be the one I would recommend because those extra 39 millimetres mean bigger fans and more cooling fins which would lead to quieter operation. I think that 300mm should fit in most modern cases because there aren't any drive bays in the front of modern towers anymore, they're all in the basements.