I'm using the comfort mode in town or when I have a mood to drive relaxed.
On country roads, I prefer sport mode in case I need to pass a the car in front of me
. And when I'm on high speed roads (110 km/h or 130 km/h allowed), I'm still on sport but I'm on manual mode (to be able to use gear 7 and 8 and limit fuel consumption).