My new Honda Civic Sport Hatchback has the "S" (Sport) setting on the gearshift right below the "D", and so far I have not used it since I am mainly traveling around town, in lots of traffic. I am looking forward to trying out Sport mode when on a trip sometime, driving on expressways and turnpikes, etc., as that is where something like this will really shine.
Our Ford Escape has the same setting. It also has 'flappy paddle' gear changer thingies on the steering wheel. I find the sport setting good for accelerating in front of idiots at the lights, but it has another use. We have a few roads in the area which are very steep and bendy. Putting the car in sports mode is good for going up, but also for going down. Automatic gearboxes just tend to freewheel down steep hills as fast as they can go. However, by putting in sports mode, and using the flappy paddles, I can lock it in a low gear and use the engine as a brake, just as I would with a manual car.