I have a sport so the height doesn't change but I tend to use either Comfort (75% of the time) or Automatic (20% of the time) or very rarely when I fancy a hoon about, Dynamic (5% of the time). All are at the same ride height except Automatic and Dynamic which lower another 5mm after 20 seconds above 77mph.
I have 275/35/20 tyres, so I tend to use Comfort a lot to make it as smooth, quiet and comfy as possible.