This topic always seems to cause a lot of confusion.
The comfort/sport switches (C/S) are found on older mercedes. They make the box behave more "sportier" in S mode. And if I recall correctly (I'm getting senile!

), my W126 had E/S on the box (economy/standard)...
However, on modern drive-by-wire cars, it seems to me that the accelerator pedal and over style of driving is what primarily defines the box' behaviour in terms of comfort/sporty character.
For example, if I accelerate gently and calmly, feathering the accelerator, my box will shift up quicker, whereas with harder and deeper accelerator pedal action the upshift is delayed and the engine climbs higher in its revs. W specifically is for winter driving, where you want to drive off in 2nd and shift up early enough to improve handling on wet and slippery roads.
The suspension has its own,
separate, setting for comfort/sport1/sport2.