It's pretty bad, even in the "colonies." While the top on my 2000 SL500 has a liner, it has no padding for sound insulation. The problem is particularly bad when driving into a headwind on a gusty day. And while definitely still audible, the wind noise isn't as bad on a calm day or with tailwind.
Solution???? Get a 2003 SL