Well, someone else mentioned Mennekes first in this thread (not me) and only the three-phase version is really an issue with the Model S connector. If you are using Mennekes with single phase you don't need all 7 pins (5 pins is fine, just like with the J1772 -> Mennekes or Tesla Roadster -> Mennekes adapter), so there is no need for another connector in the trunk.
What's really "a standardized DC protocol" at this point? Are you talking about J1772-DC?
I'm actually not that optimistic about a CHAdeMO adapter. Just the fact that they have chosen to design a separate connector and the fact that they plan to build a supercharger network kind of gives me pause. It would depend really on if the consumer demand is overwhelming; if not, I think Tesla wants to push their own DC standard instead.
Right now the CHAdeMO network in the US isn't that big and J1772-DC might come out next year (which might make some locations wait and see). I think the likelihood of a Model S to J1772-DC adapter is much, much more likely than CHAdeMO (since J1772-DC only adds two big power pins, while the rest of the pins are just standard J1772, which the Model S already has a direct physical adapter to; if the two original smaller power pins are not used during DC charging, even a direct physical adapter will work without the need of an external box).