Not much difference these days.
At low rpm, triple fan coolers are capable of the same level of cooling as dual, while being quieter. It's lost some credibility to 'zero fan' mode; the fans will be off when the card isn't in use.
Now, that feature isn't on all models, so you'll have to look up which ones do and don't.
Theoretically, it should be superior to dual at max rpm, or close to max, but most people don't run their fans like that, even when playing games, ~so...
¯\(ツ)/¯