The benefit was originally designed for cards that charge a foreign currency fee but no foreign transaction fee. In this case, DCC would save you the 3% charge from your issuer and therefore might be useful.

All credit cards that I know of in the US now charge the same fee for all foreign transactions, regardless of currency, which defeats the purpose of DCC. I am not sure about issuers in other countries but I imagine it's similar.