My car has D, 3, and L. Selecting sport mode will make L stay in 2nd, while economy mode will make it aggressively downshift to 1st, so all gears are manually selectable with some practice.
I'll use 3 for engine braking on long downhills at highway speeds. L + sport or L + economy sometimes in slow traffic so I don't need to touch the brakes unless I'm actually stopping.
Towing a trailer in town I use 3, but at highway speed have enough torque to keep it in D without hunting.
When climbing a steep grade at elevation I use 3 to keep the torque converter locked and keep ATF temps down.